drjobs Data / BI Architect.

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Pontiac, MI - USA

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

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;

Employment Type

Full-time

Company Industry

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.