Data / BI Architect.

Elegant Enterprise- Wide Solutions Inc

Job Location:

Pontiac, MI - USA

Monthly Salary: Not Disclosed

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

Data / BI Architect.

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

Experience Level: 5 years

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 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 incl. on-prem cloud & SaaS;

Data / BI Architect. 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 access...