Data Analytics Engineer (Somerset County) at Dale WorkForce Solutions

Client: manufacturing companyLocation: 5x per week Somerset, NJType: direct hirePosition Overview Our client is a publicly traded, globally recognized technology and manufacturing organization that relies on data-driven insights to support operational excellence, strategic decision-making, and digital transformation. They are seeking a Power BI Developer to design, develop, and maintain enterprise reporting solutions, data pipelines, and data warehousing assets.This role works closely with internal stakeholders across departments to ensure reporting accuracy, data availability, and the long-term success of the company's business intelligence initiatives. The position also plays a key role in shaping BI strategy and fostering collaboration across cross-functional teams.This role is on-site five days per week in Somerset, NJ.Key Responsibilities Power BI Reporting & AdministrationLead the design, development, and deployment of Power BI and SSRS reports, dashboards, and analytics assetsCollaborate with business stakeholders to gather requirements and translate needs into scalable technical solutionsDevelop and maintain data models to ensure accuracy, consistency, and reliabilityServe as the Power BI tenant administrator, partnering with security teams to maintain data protection and regulatory complianceOptimize Power BI solutions for performance, scalability, and ease of useETL & Data WarehousingDesign and maintain data warehouse structures, including schema and database layoutsDevelop and support ETL processes to ensure timely and accurate data ingestionIntegrate data from multiple systems while ensuring quality, consistency, and completenessWork closely with database administrators to optimize data warehouse performanceTroubleshoot data pipelines, ETL jobs, and warehouse-related issues as neededTraining & DocumentationCreate and maintain technical documentation, including specifications, mappings, models, and architectural designsDocument data warehouse processes for reference, troubleshooting, and ongoing maintenanceManage data definitions, lineage documentation, and data cataloging for all enterprise data modelsProject ManagementOversee Power BI and reporting projects, offering technical guidance to the Business Intelligence teamCollaborate with key business stakeholders to ensure departmental reporting needs are metRecord meeting notes in Confluence and document project updates in JiraData GovernanceImplement and enforce data governance policies to ensure data quality, compliance, and securityMonitor report usage metrics and follow up with end users as needed to optimize adoption and effectivenessRoutine IT FunctionsResolve Help Desk tickets related to reporting, dashboards, and BI toolsSupport general software and hardware installations when neededOther ResponsibilitiesManage email and phone communication professionally and promptlyRespond to inquiries to resolve issues, provide information, or direct to appropriate personnelPerform additional assigned duties as neededQualifications RequiredMinimum of 3 years of relevant experienceBachelor's degree in Computer Science, Data Analytics, Machine Learning, or equivalent experienceExperience with cloud-based BI environments (Azure, AWS, etc.)Strong understanding of data modeling, data visualization, and ETL tools (e.g., SSIS, Azure Synapse, Snowflake, Informatica)Proficiency in SQL for data extraction, manipulation, and transformationStrong knowledge of DAXFamiliarity with data warehouse technologies (e.g., Azure Blob Storage, Redshift, Snowflake)Experience with Power Pivot, SSRS, Azure Synapse, or similar reporting toolsStrong analytical, problem-solving, and documentation skillsExcellent written and verbal communication abilitiesHigh attention to detail and strong self-review practicesEffective time management and organizational skills; ability to prioritize workloadProfessional, adaptable, team-oriented, and able to thrive in a dynamic environment