Data Analyst

TechDigital Group; Brookhaven (WV); On-site; USD 90,000 - 120,000; Full time

Job summary

A technology consulting firm located in West Virginia is seeking an experienced professional in data engineering. You will build and maintain data models, optimize data structures, and ensure effective communication with stakeholders regarding data solutions. Ideal candidates should possess a technical degree, along with significant experience in database management and ETL processes. Strong analytical and communication skills are essential for success in this role, which offers the chance to work on cutting-edge data warehousing solutions.

Qualifications

• Technical Degree required. B.S or M.S in Computer Science, Business Analytics, Engineering.
• 8+ years of strong working knowledge of databases (Snowflake, MS-SQL, SAP HANA).
• 5+ years building scalable ETL pipelines with data processing and/or developing applications and data sources.

Responsibilities

• Build and maintain data models and data/solution pipelines.
• Design and optimize data structures in data management systems.
• Determine transformation requirements for structured and unstructured data.

Job description

What's Encouraged Daily

• Build and maintain data models and data/solution pipelines to cater to analytical applications
• Work in a technical team through development, deployment, and application of applied, predictive and prescriptive analytics using data engineering, machine learning engineering and artificial intelligence.
• Design and optimize data structures in data management systems (Snowflake, GCP, HANA) to enable reporting analytics using Tableau/Power BI as well as AI/Client solutions.
• Determine transformation requirements and develop processes to bring structured and unstructured data from the source to a new physical Data Model

How To Qualify

• Technical Degree required. B.S or M.S in Computer Science, Business Analytics, Engineering
• Understanding of Data Engineering/processing, Business Intelligence and Advanced analytics using Teamcenter data
• Thorough understanding of the back-end models for Teamcenter
• 8+ years of strong working knowledge of databases (Snowflake, MS-SQL, SAP HANA)
• 5+ years building scalable ETL pipelines with data processing and/or developing applications and data sources.
• Experience with the back-end data structures, tables, relationships, E-R relationship of Teamcenter and translating them to data warehouse constructs.
• Ability to define & build hierarchical relationships of Product Lifecycle Management like BOM, etc. in data warehouse like Snowflake.
• Communicate effectively with stakeholders regarding all facets of data warehousing solutions pertaining to PLM Teamcenter.
• Ability to architect & develop solutions pertaining to attributes, relationships for master data including slowly changing dimensions.
• Ability to architect & develop data-warehousing solutions for extended Product Lifecycle Management encompassing production cycle definitions of products, equipment, facilities, etc.
• Familiarity with the integration of Teamcenter & SAP as related to data warehousing solutions.
• Various phases of Unit, Integration & User Acceptance testing
• Familiarity with software architecture (data structures, data schemas, etc.)
• Software development skills and knowledge in Cloud based data engineering.
• CI/CD pipelines including ADO repos
• Experience with various frameworks and processes, such as Agile (Scrum, Kanban, etc.)
• Outstanding analytical thinking, interpersonal, oral, and written communication skills. Proficiency in the Microsoft Office suite
• Ability to prioritize and meet critical project timelines in a fast-paced environment.
• Self-motivated and team-oriented

What Sets You Apart

• Strong business domain knowledge in Product Lifecycle Management.
• Experience with 3NF data modeling
• Experience with transformation & development of data models in Snowflake.
• Experience with Coalesce