Data/BI Architect Job at Elegant Enterprise-Wide Solutions, Inc., Pontiac, MI

c09HL2xlQVM3L0Z3MVBTOFphaVczOWpFYWc9PQ==
  • Elegant Enterprise-Wide Solutions, Inc.
  • Pontiac, MI

Job Description

About this Position:

Job Title: Data/BI Architect

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.

Experience Level: 5+ years.

Environment:

  • 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: For H-1B and OPT cases, we are seeking candidates from recognised organizations.

"No phone calls please."

Job Tags

H1b,

Similar Jobs

Insight Global

Senior Contract Analyst Job at Insight Global

 ...Projects for various departments specifically within the Construction, Design and Engineering capacities. This position holds many hats related to preparation of specifications, bidding processes, preparation, renewal, and monitoring of professional services contracts... 

U.S. Tsubaki Power Transmission, LLC

Fall Intern, Engineering (SDKY) Job at U.S. Tsubaki Power Transmission, LLC

 ...service. U.S. Tsubaki is a leading manufacturer and supplier of power transmission and motion control products. As a part of a vast, international network of corporate and industrial resources, Tsubaki offers its customers the finest state-of-the-art products available in... 

Sierra HR Partners

Certified Public Accountant (CPA) Job at Sierra HR Partners

 ...serves clients in Fresno and throughout California. We are currently looking to hire an experienced, highly technical, and motivated CPA to join our firm. Candidates should have the ability to professionally manage tax engagements and/or audit and review engagements.... 

Compunnel Inc.

Senior Security Analyst Job at Compunnel Inc.

 ...with internal business customers to determine security requirements. Provides technical advice and counsel to less experienced analysts. Required to assist in maintaining 24 X 7 systems availability. IMMEDIATE MANAGER: Manager, Information Security or Manager... 

84 Lumber

MULTI-FAMILY PROJECT MANAGER Job at 84 Lumber

The Project Manager reports directly to the Construction Operations Manager. The PM is the direct supervisor of assigned estimator(s). The PM is responsible for the solicitation of project documents and information, ensures that all information is put into the hands of...