Data Analytics Developer

Talent Management Plus, Inc.; Addison (IL); On-site; USD 90,000 - 120,000; Full time

Job summary

Talent Management Plus, Inc. is seeking a Data Analytics Developer to lead enterprise applications development, delivering BI, reporting and analytics to support Sales, Operations and Shared Services.

The role drives Advanced Analytics capabilities to capture market share and improve decision making with data. The candidate should have 5+ years in BI analytics, 2+ years in Power BI and ETL, and strong data modeling and SQL Server experience.

Qualifications

• Bachelor's degree in CS, engineering or IS.
• 5+ years of BI analytics experience.
• 2+ years developing BI reports and dashboards in Power BI.
• 2 years of Integration/ETL experience.
• Experience in Advanced Analytics: optimization, ML or predictive analytics.
• Experience with ETL techniques and data modeling patterns.
• Experience with SQL Server RDBMS.
• Experience with Agile methodology.
• Industry experience in manufacturing/distribution a plus.

Responsibilities

• Perform BI solution development activities including requirements gathering, design, ETL, testing and dashboards.
• Develop & support backend data model, SSIS ETL and Power BI analytics & reporting.
• Review, interpret, and debug complex code; develop maintainable code via structure and comments.
• Generate automated, repeatable, and stable processes to support data transformation, load, movement and synchronization.
• Collaborate with business and technology leaders to align analytics with enterprise objectives.

Skills

BI Analytics

Power BI

ETL

Advanced Analytics

SQL/ RDBMS

Data Modeling

Data Integration

Agile Methodology

Industry experience (manufacturing/dis

Education

Bachelor's degree in Computer Science, Engineering or Information Systems

Tools

SSIS

SQL Server

Job description

Position: Data Analytics Developer
Location: Addison, IL or Detroit MI
Duration: Full Time

Description: Data Analytics developer to lead in the development and delivery of enterprise applications to support business strategy and growth. Works with business and technology leaders to understand the enterprise objectives and build capabilities in BI, Reporting & Analytical applications to support Sales, Operations and Shared Services. This role will also be instrumental in advancing client's Advanced Analytics capabilities to lead the industry in the utilization of data to capture market share.

Responsibilities:

Solution Delivery

• Perform BI solution development activities including requirements gathering, functional design, technical specifications, ETL design & development, unit & integration testing and reports & dashboard development
• Develop & support backend data model, SSIS ETL and Power BI Analytics & Reporting & Dashboards
• Review, interpret, and debug complex code. Develop maintainable code via proper structures, comments, and design
• Generate automated, repeatable and stable processes to support data transformation, data load, data movement, and data synchronizations

Solution Definition, Data Architecture & Strategy

• Perform source data analysis - data profiling, validation, conceptual and logical data modeling, etc. - to determine the suitability of the source data for meeting the reporting requirements
• Meet with subject matter experts in different areas of the business, be able to quickly learn the concepts and business language relevant to their line of business, and develop an understanding of how their data supports their business processes
• Assist in developing the roadmap for Analytics and Advanced Analytics across the company to enable the business strategy

Required Skills:

• Bachelor's degree in Computer Science, Engineering or Information Systems or related
• 5+ years of relevant experience in BI Analytics
• 2+ years developing BI reports and Dashboards in Power BI or equivalent BI tools
• 2 years of Integration / ETL experience
• Experience in Advanced Analytics: Optimization, ML and/or Predictive Analytics
• Experience with ETL techniques and concepts (e.g. - change data capture, slowly changing dimensions, managing exceptions, set based / bulk processing)
• Experience in data modeling and entity relationship diagram conventions and various data modeling patterns (e.g. - dimensional model, 3rd normal form)
• Experience with relational databases, including an understanding of SQL Server Database Management Systems (RDBMS) concepts
• Experience with Microsoft application development
• Experience with the Agile Methodology
• Experience in manufacturing/distribution or related industries a plus