Elegant Enterprise-Wide Solutions, Inc.
Data/BI Architect
Elegant Enterprise-Wide Solutions, Inc., Pontiac, Michigan, United States, 48340
Overview
Elegant Enterprise-Wide Solutions Inc- 23 years of rich experience in State and Federal Contracts- IT Consulting and IT Solutions Job Title: Data/BI Architect 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. Qualifications
Experience Level:
5+ years. 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. ML/DL/Analytic Engines:
TensorFlow, PyTorch, Trillium, Apache Spark. Modeling Tools:
MS Visio, ER/Studio, PowerDesigner; Source systems incl. on-prem, cloud, & SaaS. Note:
For H-1B and OPT cases, we are seeking candidates from recognised organizations. No phone calls please. Position Details
Seniority level:
Mid-Senior level Employment type:
Contract Job function:
Consulting, Human Resources, and Information Technology Industries:
Staffing and Recruiting, IT Services and IT Consulting, and Software Development
#J-18808-Ljbffr
Elegant Enterprise-Wide Solutions Inc- 23 years of rich experience in State and Federal Contracts- IT Consulting and IT Solutions Job Title: Data/BI Architect 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. Qualifications
Experience Level:
5+ years. 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. ML/DL/Analytic Engines:
TensorFlow, PyTorch, Trillium, Apache Spark. Modeling Tools:
MS Visio, ER/Studio, PowerDesigner; Source systems incl. on-prem, cloud, & SaaS. Note:
For H-1B and OPT cases, we are seeking candidates from recognised organizations. No phone calls please. Position Details
Seniority level:
Mid-Senior level Employment type:
Contract Job function:
Consulting, Human Resources, and Information Technology Industries:
Staffing and Recruiting, IT Services and IT Consulting, and Software Development
#J-18808-Ljbffr