Data / BI Architect

V2Soft, Inc; Pontiac (MI); On-site; USD 120,000 - 160,000; Full time

Job summary

V2Soft, Inc. is seeking a Data Business Intelligence Architect to bridge data architecture, engineering and business strategy. The role designs and maintains data strategy ensuring data is accessible, reliable and secure for analysis and decision-making.

The candidate will architect data solutions for descriptive, diagnostic, predictive and prescriptive analytics, collaborating with stakeholders and leading technical teams. On-site at OCIT Building at least two days per week.

Qualifications

• Experience designing scalable data architectures and data warehouses/lakes.
• Knowledge of data governance, security, and metadata management.
• Ability to translate business needs into technical data solutions.

Responsibilities

• Collaborate with business and IT stakeholders to gather data requirements.
• Architect and implement data solutions including warehouses, lakes, and marts.
• Evaluate and select tools aligned with architecture and business needs.
• Design and manage ETL/ELT pipelines to move data into the warehouse.
• Create and maintain an enterprise data catalog and metadata standards.
• Govern data quality, security and enable self-service data discovery.
• Monitor BI systems and pipelines for performance and cost efficiency.
• Provide technical leadership and mentorship in data management and BI development.

Skills

Data platforms

Databases

BI tools

ETL/ELT tools

Big data

Programming APIs

ML/DL engines

Modeling tools

Source systems

Job description

Data Business Intelligence (BI) Architect

V2Soft is a global leader in IT services and business solutions, delivering innovative and cost-effective technology solutions worldwide since 1998. We partner with Fortune 500 companies to address complex business challenges. Our services span AI, IT staffing, cloud computing, engineering, mobility, testing, and more. Join us to be part of a dynamic and impactful global company!

The 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 requirements & 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.

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, Looker
• ETL/ELT: Cloud native (AWS Glue, Azure Data Factory, Google Cloud Dataflow) & in-warehouse transform tools (Fivetran, Talend, dbt)
• Big Data Tech: Hadoop, Spark, Kafka
• Programming/API: Python, Keras, Scikit-learn, R, XML
• ML/DL/Analytic Engines: TensorFlow, PyTorch, Trillium, Apache Spark
• Modeling Tools: MS Visio, ER/Studio, PowerDesigner
• Source systems: on-prem, cloud, & SaaS

Must 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.