25th August, 2025
Data / BI Architect #1034890
Job Description:
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, 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;
- Must be able to be on-site at OCIT Building a MINIMUM of two days a week.
Additional Info: At FastTek Global,
Our Purpose is
Our People and
Our Planet. We come to work each day and are reminded we are
helping people find their success stories. Also,
Doing the right thing is our mantra. We act responsibly, give back to the communities we serve and have a little fun along the way.
We have been doing this with pride, dedication and plain, old-fashioned hard work for
24 years!
FastTek Global is financially strong, privately held company that is
100% consultant and
client focused.
We've differentiated ourselves by being
fast, flexible, creative and
honest. Throw out everything you've heard, seen, or felt about every other IT Consulting company. We do unique things and we do them for Fortune 10, Fortune 500, and technology start-up companies.
Our benefits are second to none and thanks to our
flexible benefit options you can choose the benefits you need or want, options include:
- Medical and Dental (FastTek pays majority of the medical program)
- Vision
- Personal Time Off (PTO) Program
- Long Term Disability (100% paid)
- Life Insurance (100% paid)
- 401(k) with immediate vesting and 3% (of salary) dollar-for-dollar match
Plus, we have a lucrative employee referral program and an employee recognition culture.
FastTek Global was named one of the
Top Work Places in Michigan by the Detroit Free Press in
2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021 2022 and 2023! To view all of our open positions go to: https://www.fasttek.com/fastswitch/findwork
Follow us on Twitter: https://twitter.com/fasttekglobal
Follow us on Instagram: https://www.instagram.com/fasttekglobal
Find us on LinkedIn: https://www.linkedin.com/company/fasttek
You can become a fan of FastTek on Facebook: https://www.facebook.com/fasttekglobal/
Apply For Job