Data Business Intelligence Architect

IO Datasphere, Inc. has been providing project management, software development and IT staff augmentation services to our clients in the Midwest and throughout the U.S. since 1996. We are an approved vendor on contract to provide software development and IT staff augmentation services for the States of Illinois, Michigan, Minnesota, Iowa, and Wisconsin. We also provide these services to businesses, as well as local and county governments, in the Midwest and nationwide. Our client is looking for a Data Business Intelligence Architect. This role is a hybrid of data architecture, engineering & business strategy, bridging the gap between tech data solutions & business objectives. The right candidate has experience in architecting data solutions that can be used for descriptive, diagnostic, predictive & prescriptive analytic solutions. Tasks

• Designs, develops & maintains the overall data strategy ensuring the County data in scope is accessible, reliable & secure for analysis and decision-making.
• Stakeholder Collaboration
• Data Architect Design & Data Modeling
• ETL/ELT Pipeline Management
• Data Catalog & Metadata Management
• Data Governance and Discovery
• Performance Optimization
• Technical Leadership

Environment: Example of Technology 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 NOTE: Local candidates preferred. This is a Hybrid position. Must be able to be on-site in Waterford, MI MINIMUM of two days a week. Location: Waterford, MI (Hybrid) Contract: 1-2 years Skills Required:

• 5+ years - Experience working with business & IT stakeholders to gather requirements & translate business needs into tech specifications, including identification of data sources.
• 5+ years - Experience with architect & implementing scalable, secure & efficient data solutions, including data warehouses, data lakes, and/or data marts. Design conceptual, logical & physical data models.
• 5+ years - Experience evaluating, recommending & implementing tools aligned with recommended architecture, including visualization tools aligned with business needs.
• 5+ years - Experience designing, developing & testing data pipelines, integrations to source mgt & ETL / ELT processes to move data from various sources into the data warehouse
• 5+ years - Experience designing, creating & maintaining an enterprise-wide data catalog, automating metadata ingestion, establishing data dictionaries, and ensuring that all data assets are properly documented & tagged.
• 5+ years - Experience enforcing 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.
• 5+ years - Experience monitoring & optimizing BI systems & data pipelines to ensure high performance, reliability & cost-effectiveness.
• 5+ years - Experience providing technical guidance & mentorship across an organization, establishing best practices for data mgt & BI development

*** Rate depends on experience *** Candidates authorized to work in the US are encouraged to apply. We can accept H1b, , TN, and other valid work visas for IT. However, we cannot accept OPT or CPT visas at this time. *** Companies submitting candidates should only submit direct W2 employees for this position. Please submit your resume by using the "URL" below Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity. Report this job

• Dice Id: 10193654
• Position Id: 10143MI-D