Zencon Group Inc. · 5 months ago
Data / BI Architect (Hybrid)
Oakland County, MI, MI
Full-time
Hybrid
Senior Level
5+ years expZencon Group Inc. is seeking a Data Business Intelligence (BI) Architect who will bridge the gap between technical data solutions and business objectives. The role involves designing, developing, and maintaining the overall data strategy to ensure data accessibility, reliability, and security for analysis and decision-making.
AnalyticsConsultingInformation Technology
Responsibilities
Work closely with business & IT stakeholders to gather req & translate business needs into tech specifications, including identification of data sources
Architect & implement scalable, secure & efficient data solutions, including data warehouses, data lakes, and/or data marts
Design conceptual, logical & physical data models
Evaluate, recommend & implement tools aligned with recommended architecture, including visualization tools aligned with business needs
Design, develop & test data pipelines, integrations to source mgt & ETL / ELT processes to move data from various sources into the data warehouse
Design, create & maintain an enterprise-wide data catalog, automating metadata ingestion, establishing data dictionaries, and ensuring that all data assets are properly documented & tagged
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
Monitor & optimize BI systems & data pipelines to ensure high performance, reliability & cost-effectiveness
Provide technical guidance & mentorship across the organization, establishing best practices for data mgt & BI development
Qualification
Required
5+ years of experience in data architecture, engineering & business strategy
Experience in architecting data solutions for descriptive, diagnostic, predictive & prescriptive analytic solutions
Ability to work closely with business & IT stakeholders to gather requirements & translate business needs into technical specifications
Experience in architecting & implementing scalable, secure & efficient data solutions, including data warehouses, data lakes, and/or data marts
Ability to design conceptual, logical & physical data models
Experience in evaluating, recommending & implementing tools aligned with recommended architecture
Ability to design, develop & test data pipelines, integrations to source management & ETL/ELT processes
Experience in designing, creating & maintaining an enterprise-wide data catalog
Ability to enforce data governance policies ensuring data quality, security & compliance
Experience in monitoring & optimizing BI systems & data pipelines
Ability to provide technical guidance & mentorship across the organization
Preferred
Experience with data platforms including dimensional modeling & cloud services (S3, AWS Redshift, RDS, Azure Data Lake Storage, Synapse Analytics, BigQuery, Databricks, Snowflake, Informatica)
Experience with SQL & relational/non-relational databases (SQL Server, Oracle, PostgreSQL, MongoDB)
Experience with BI tools such as Power BI, Business Objects, Tableau, Crystal, Looker
Experience with cloud native ETL/ELT tools (AWS Glue, Azure Data Factory, Google Cloud Dataflow) & in-warehouse transform tools (Fivetran, Talend, dbt)
Experience with big data technologies (Hadoop, Spark, Kafka)
Programming experience in Python, Keras, Scikit-learn, R, XML
Experience with ML/DL/Analytic engines (TensorFlow, PyTorch, Trillium, Apache Spark)
Experience with modeling tools (MS Visio, ER/Studio, PowerDesigner)
Company
Zencon Group Inc.
ZENCON GROUP: Empowering Digital Transformation, Service Excellence & Workforce Innovation Zencon Group is a global IT consulting firm and certified Microsoft Partner delivering high-performance digital solutions that help organizations modernize operations, elevate customer and citizen experiences, and scale with confidence.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase