Senior Client Reporting & Data Automation Analyst

Dormont Manufacturing Co; New York (NY); On-site; USD 25,000 - 37,000; Full time

Job summary

Dormont Manufacturing Co. seeks a seasoned Client Reporting Analyst to design, automate, and maintain reports and dashboards for management decision making. The role involves ETL development, data modeling, and collaboration with stakeholders to translate requirements into technical specs.

You will build scalable data pipelines, ensure data quality, and contribute to end-to-end reporting platforms for Global Markets Operations. 40-hour weeks in NY is expected.

Qualifications

• 5+ years of experience in data warehousing, data modeling, building data pipelines, and data visualizations.
• Experience orchestrating data using directed acyclic graph (DAG) concepts.
• Experience providing data solutions for reporting and analytics teams.
• Ability to manage multiple deliverables simultaneously.
• Extreme attention to detail.
• Experience with code management tools such as GIT.
• Advanced MS SQL knowledge and experience working with relational databases.

Responsibilities

• Designs, develops, and maintains innovative automated reports, dashboards, and scorecards using BI tools including MicroStrategy and Tableau.
• Designs, develops, and maintains automated data ETL processes from various database platforms, storing data in relational tables.
• Analyzes disparate database sources including relational structures, dimensional models, and cubes.
• Designs and builds relational data models to support reports, dashboards, and scorecards.
• Partners with business stakeholders to translate business requirements into technical specifications.
• Creates and maintains required standard documentation including metadata and workflows.
• Works collaboratively in a cross-functional team and provides updates on project calls.
• Assembles large, complex data sets meeting functional and non-functional requirements.
• Maintains, improves, cleans, and manipulates large data for operations and analytics.
• Builds complex processes supporting data transformation, structures, metadata, data quality controls, and workload management.
• Design, develop, and implement scalable data pipelines ingesting data from external sources for BI analytics teams.
• Identify, troubleshoot, and resolve performance and process issues.
• Leverage processes to monitor data quality and ensure production data availability.

Skills

Automation

Data Mining

Data Quality Management

Data Visualization

Reporting

Agile Practices

Attention to Detail

DevOps Practices

Production Support

Technical Documentation

Business Acumen

Business Process Analysis

Continuous Improvement

Innovative Thinking

Quality Assurance

Job description

Dormont Manufacturing Co. seeks a seasoned Client Reporting Analyst to design, automate, and maintain reports and dashboards for management decision making. The role involves ETL development, data modeling, and collaboration with stakeholders to translate requirements into technical specs.

You will build scalable data pipelines, ensure data quality, and contribute to end-to-end reporting platforms for Global Markets Operations. 40-hour weeks in NY is expected.