Sign upLog in

Data / BI Architect

V2Soft, Inc

Pontiac, Michigan

Apply
JOB DETAILS
JOB TYPE
Full-time
SKILLS
Amazon Relational Database Service (RDS), Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Analysis Skills, Apache, Apache Hadoop, Apache Spark, Application Programming Interface (API), Artificial Intelligence (AI), Best Practices, Big Data, Business Intelligence, Business Intelligence Software, Business Solutions, Business Strategy, Capability Maturity Model Integration (CMMI), Cloud Computing, Community Support, Cost Effectiveness Analysis, Data Lake, Data Management, Data Mart, Data Modeling, Data Modeling Tools, Data Processing, Data Quality, Data Storage, Data Warehousing, Database Extract Transform and Load (ETL), Dimensional Modeling, Embarcadero ER/Studio, Fortune 500 Customers, High Reliability, ISO (International Organization for Standardization), Informatica, Information/Data Security (InfoSec), Mentoring, Metadata, Microsoft SQL Server, Microsoft Visio, Microsoft Windows Azure, MongoDB, Nonprofit, Oracle Database, Performance Analysis, Performance Management, Performance Tuning/Optimization, PostgreSQL, Power BI, Python Programming/Scripting Language, R Programming Language, SAP BusinessObjects, SQL (Structured Query Language), Sales Pipeline, Snowflake Schema, Software Engineering, Source Code/Configuration Management (SCM), Tableau, Technical Leadership, Technical Recruiting, Technical Support, Test Data, Test Plan/Schedule, Testing, Training Data Sets, Warehousing
LOCATION
Pontiac, Michigan
POSTED
3 days ago
Data Business Intelligence (BI) ArchitectV2Soft is a global leader in IT services and business solutions, delivering innovative and cost-effective technology solutions worldwide since 1998. We have headquarters in Bloomfield Hills, MI and have 16 offices spread across six countries. We partner with Fortune 500 companies to address complex business challenges. Our services span AI, IT staffing, cloud computing, engineering, mobility, testing, and more. Certified with CMMI Level 3 and ISO standards, V2Soft is committed to quality and security. Beyond our work, we actively support local communities and non-profits, reflecting our core values. Join us to be part of a dynamic and impactful global company!Data Business Intelligence (BI) Architect role is a hybrid of data architecture, engineering & business strategy, bridging the gap between tech data solutions & business objectives. Designs, develops & maintains the overall data strategy ensuring the County data in scope is accessible, reliable & secure for analysis and decision-making. The right candidate has experience in architecting data solutions that can be used for descriptive, diagnostic, predictive & prescriptive analytic solutions.Key Responsibilities:Stakeholder Collaboration: Work closely with business & IT stakeholders to gather req & translate business needs into tech specifications, including identification of data sources.Data Arch Design & Data Modeling: Architect & implement scalable, secure & efficient data solutions, including data warehouses, data lakes, and/or data marts. Design conceptual, logical & physical data models.Tool and Platform Selection: Evaluate, recommend & implement tools aligned with recommended architecture, including visualization tools aligned with business needs.ETL/ELT Pipeline Mgt: Design, develop & test data pipelines, integrations to source mgt & ETL / ELT processes to move data from various sources into the data warehouse.Data Catalog & Metadata Mgt: Design, create & maintain an enterprise-wide data catalog, automating metadata ingestion, establishing data dictionaries, and ensuring that all data assets are properly documented & tagged.Data Governance and Discovery: Enforce data governance policies through the data catalog, ensuring data quality, security & compliance. Enable self-service data discovery for users by curating & organizing data assets in an intuitive way.Performance Optimization: Monitor & optimize BI systems & data pipelines to ensure high performance, reliability & cost-effectiveness.Technical Leadership: Provide technical guidance & mentorship across the organization, establishing best practices for data mgt & BI development. Environment Role incl. defining data platform tech stack.Example tech below; not required to have experience in all.Data Platforms: DW & lake concepts incl. dimensional modeling & cloud services (S3, AWS Redshift, RDS, Azure Data Lake Storage, Synapse Analytics, BigQuery, Databricks, Snowflake, Informatica)Databases: SQL & relational/non-relational (SQL Server, Oracle, PostgreSQL, MongoDB)BI Tools: Power BI, Business Objects, Tableau, Crystal, LookerETL/ELT: Cloud native (AWS Glue, Azure Data Factory, Google Cloud Dataflow) & in-warehouse transform tools (Fivetran, Talend, dbt)Big Data Tech: Hadoop, Spark, KafkaProgramming/API: Python, Keras, Scikit-learn, R, XMLML/DL/Analytic Engines: TensorFlow, PyTorch, Trillium, Apache SparkModeling Tools: MS Visio, ER/Studio, PowerDesignerSource systems incl. on-prem, cloud, & SaaSMust be able to be on-site at OCIT Building a MINIMUM of two days a week.V2Soft is an Equal Opportunity Employer (EOE). We welcome applicants from all backgrounds, including individuals with disabilities and veterans.

About the Company

V

V2Soft, Inc