Job ID: 25-28536
Job Title: Data / BI Architect
Location: Pontiac, MI (Hybrid)
Duration: 1–2 Years
Pay Rate: $60–65/hour (W2)
We are seeking a highly skilled Data / Business Intelligence (BI) Architect to lead the design, development, and maintenance of enterprise data solutions. This role bridges technical data architecture with business strategy, ensuring data is reliable, secure, and accessible for advanced analytics and decision-making.
The ideal candidate has expertise in architecting scalable solutions for descriptive, diagnostic, predictive, and prescriptive analytics.
Stakeholder Collaboration: Partner with business and IT teams to translate requirements into technical solutions, including identification of data sources.
Data Architecture & Modeling: Architect and implement scalable, secure, and efficient data solutions such as data warehouses, data lakes, and data marts. Develop conceptual, logical, and physical data models.
Tool & Platform Selection: Evaluate and recommend BI tools and platforms that align with business needs and technical strategy.
ETL/ELT Pipeline Management: Design, build, and optimize data pipelines and ETL/ELT processes for integrating multiple data sources.
Data Catalog & Metadata Management: Create and maintain an enterprise-wide data catalog, automate metadata ingestion, and establish data dictionaries.
Data Governance & Discovery: Enforce data governance policies, ensure compliance, and enable intuitive self-service data discovery.
Performance Optimization: Monitor and improve BI systems and pipelines for efficiency, reliability, and cost-effectiveness.
Technical Leadership: Provide mentorship, establish best practices, and guide teams in data management and BI development.
Data Platforms: Data warehouses, data lakes, dimensional modeling, and cloud services (AWS Redshift, S3, RDS, Azure Data Lake, Synapse, BigQuery, Snowflake, Databricks, Informatica).
Databases: SQL Server, Oracle, PostgreSQL, MongoDB.
BI Tools: Power BI, Tableau, Business Objects, Crystal Reports, Looker.
ETL/ELT Tools: AWS Glue, Azure Data Factory, Google Cloud Dataflow, dbt, Talend, Fivetran.
Big Data Technologies: Hadoop, Spark, Kafka.
Programming & APIs: Python, R, XML, Keras, Scikit-learn.
ML/DL & Analytics Engines: TensorFlow, PyTorch, Trillium, Apache Spark.
Modeling Tools: MS Visio, ER/Studio, PowerDesigner.
Source Systems: On-premises, cloud, and SaaS.