About this role
<table class="MsoNormalTable" style="border-collapse:collapse;border:none" border="1" cellspacing="0" cellpadding="0"> <tbody> <tr> <td style="width:6.65in;border:solid black 1.0pt;background-color:#d9d9d9;padding:0.0in 5.4pt 0.0in 5.4pt" valign="top"> <p style="margin:2.0pt 0.0in 1.0pt;font-size:10.0pt;font-family:Calibri, sans-serif;color:#262626;font-weight:bold"><span style="font-size:11.0pt;font-family:Arial, sans-serif">Summary:</span></p> </td> </tr> <tr> <td style="width:6.65in;border:solid black 1.0pt;border-top:none;background-color:white;padding:0.0in 5.4pt 0.0in 5.4pt" valign="top"> <p style="margin:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"> </p> <p style="margin:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><span style="font-size:11.0pt;color:black">Designs, develops, and maintains enterprise data analytics solutions, business intelligence dashboards, and Microsoft Power Platform applications that drive decision-making across manufacturing operations, engineering, finance, and executive leadership. Partners with cross-functional stakeholders to transform complex data into trusted, scalable, and user-friendly products by performing the following duties.</span></p> <p style="margin:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"> </p> </td> </tr> <tr> <td style="width:6.65in;border:solid black 1.0pt;border-top:none;background-color:#d9d9d9;padding:0.0in 5.4pt 0.0in 5.4pt"> <p style="margin:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><strong><span style="font-size:11.0pt;color:black">Essential Duties and Responsibilities:</span></strong></p> </td> </tr> <tr> <td style="width:6.65in;border:solid black 1.0pt;border-top:none;background-color:white;padding:0.0in 5.4pt 0.0in 5.4pt"> <ul style="margin-top:0.0in;margin-bottom:0.0in" type="disc"> <li style="line-height:12.75pt;background-color:white;margin-top:0.0in;margin-right:0.0in;margin-bottom:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><span style="font-size:11.0pt;color:black">Design, develop, and maintain enterprise dashboards, KPI scorecards, and decision-support reporting in Power BI using SQL, DAX, and Power Query to enable executive and operational decision-making.</span></li> <li style="color:#333333;line-height:12.75pt;background-color:white;margin-top:0.0in;margin-right:0.0in;margin-bottom:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><span style="font-size:11.0pt">Build, deploy, and maintain custom business applications using Microsoft Power Apps (canvas and/or model-driven) and automate workflows using Power Automate to streamline manufacturing and back-office processes. </span></li> <li style="line-height:12.75pt;background-color:white;margin-top:0.0in;margin-right:0.0in;margin-bottom:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><span style="font-size:11.0pt;color:black">Develop and maintain semantic data models, dimensional structures, and reusable reporting layers that serve as the trusted source of truth across the organization.</span></li> <li style="line-height:12.75pt;background-color:white;margin-top:0.0in;margin-right:0.0in;margin-bottom:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><span style="font-size:11.0pt;color:black">Partner with Engineering, Operations, Finance, and Product stakeholders to gather requirements, define KPIs, and deliver multi-workstream analytics solutions end to end. </span></li> <li style="line-height:12.75pt;background-color:white;margin-top:0.0in;margin-right:0.0in;margin-bottom:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><span style="font-size:11.0pt;color:black">Write, optimize, and maintain complex SQL queries, stored procedures, and data extracts against enterprise data warehouses and cloud platforms (e.g., Snowflake, Azure SQL, Redshift, MySQL).</span></li> <li style="line-height:12.75pt;background-color:white;margin-top:0.0in;margin-right:0.0in;margin-bottom:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><span style="font-size:11.0pt;color:black">Use Python or similar scripting languages for data analysis, automation, integration, and quality validation tasks.</span></li> <li style="line-height:12.75pt;background-color:white;margin-top:0.0in;margin-right:0.0in;margin-bottom:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><span style="font-size:11.0pt;color:black">Champion self-service analytics by consolidating recurring ad-hoc requests into governed, scalable dashboards and apps, and by enabling business users through training and documentation.</span></li> <li style="line-height:12.75pt;background-color:white;margin-top:0.0in;margin-right:0.0in;margin-bottom:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><span style="font-size:11.0pt;color:black">Validate, QA, and document data products to ensure accuracy, reliability, security, and adoption; support data governance and modernization of legacy data assets.</span></li> <li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><span style="font-size:11.0pt;color:black">Other duties as assigned.</span></li> </ul> </td> </tr> <tr> <td style="width:6.65in;border:solid black 1.0pt;border-top:none;background-color:#d9d9d9;padding:0.0in 5.4pt 0.0in 5.4pt"> <p style="margin:2.0pt 0.0in 1.0pt;font-size:10.0pt;font-family:Calibri, sans-serif;color:#262626;font-weight:bold"><span style="font-size:11.0pt;font-family:Arial, sans-serif;color:black">Qualifications:</span></p> </td> </tr> <tr> <td style="width:6.65in;border:solid black 1.0pt;border-top:none;background-color:white;padding:0.0in 5.4pt 0.0in 5.4pt"> <p style="margin:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"> </p> <p style="margin:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><span style="font-size:11.0pt;color:black">To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. </span></p> <p style="margin:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"> </p> </td> </tr> <tr> <td style="width:6.65in;border:solid black 1.0pt;border-top:none;background-color:#d9d9d9;padding:0.0in 5.4pt 0.0in 5.4pt"> <p style="margin:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><strong><span style="font-size:11.0pt;color:black">Education/Experience:</span></strong></p> </td> </tr> <tr> <td style="width:6.65in;border:solid black 1.0pt;border-top:none;background-color:white;padding:0.0in 5.4pt 0.0in 5.4pt"> <ul style="margin-top:0.0in;margin-bottom:0.0in" type="disc"> <li style="color:#010101;margin-top:0.0in;margin-right:0.0in;margin-bottom:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><span style="font-size:11.0pt">Bachelor’s degree in Information Systems, Computer Science, Data Analytics, Engineering, Mathematics, or a related field; Master’s degree preferred.</span></li> <li style="color:#010101;margin-top:0.0in;margin-right:0.0in;margin-bottom:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><span style="font-size:11.0pt">3-5 years of progressive experience in data analytics, business intelligence, analytics engineering, or a closely related field.</span></li> <li style="color:#010101;margin-top:0.0in;margin-right:0.0in;margin-bottom:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><span style="font-size:11.0pt">Advanced proficiency in SQL (complex queries, joins, performance tuning, stored procedures) and demonstrated experience with Power BI (DAX, Power Query, semantic modeling, dashboard architecture).</span></li> <li style="color:#010101;margin-top:0.0in;margin-right:0.0in;margin-bottom:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><span style="font-size:11.0pt">Hands-on experience with Python for data analysis, scripting, or automation; experience designing and maintaining dimensional data models and semantic layers.</span></li> <li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><span style="font-size:11.0pt;color:#010101">Experience building applications with Microsoft Power Apps and automating workflows with Power Automate is strongly preferred; familiarity with Dataverse, SharePoint, or Microsoft 365 data sources is a plus. Manufacturing, supply chain, or operations industry experience is a plus.</span></li> </ul> </td> </tr> <tr> <td style="width:6.65in;border:solid black 1.0pt;border-top:none;background-color:#d9d9d9;padding:0.0in 5.4pt 0.0in 5.4pt"> <p style="margin:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><strong><span style="font-size:11.0pt;color:black">Certificates, Licenses, Registrations:</span></strong></p> </td> </tr> <tr> <td style="width:6.65in;border:solid black 1.0pt;border-top:none;background-color:white;padding:0.0in 5.4pt 0.0in 5.4pt"> <ul style="margin-bottom:0.0in;margin-top:0.0px"> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:7.0pt;font-family:Arial, sans-serif"><span style="font-size:11.0pt;color:black">Microsoft certifications such as PL-300 (Power BI Data Analyst), PL-400 (Power Platform Developer), or DP-900/DP-203 are preferred but not required.</span></li> </ul> </td> </tr> <tr> <td style="width:6.65in;border:solid black 1.0pt;border-top:none;background-color:#d9d9d9;padding:0.0in 5.4pt 0.0in 5.4pt"> <p style="margin:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><strong><span style="font-size:11.0pt;color:black">Language Skills: </span></strong></p> </td> </tr> <tr> <td style="width:6.65in;border:solid black 1.0pt;border-top:none;background-color:white;padding:0.0in 5.4pt 0.0in 5.4pt"> <ul style="margin-top:0.0in;margin-bottom:0.0in" type="disc"> <li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><span style="font-size:11.0pt;color:black">Ability to read, write, and communicate fluently in English; strong written and verbal communication skills for translating technical concepts for non-technical stakeholders. </span></li> <li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><span style="font-size:11.0pt;color:black">Ability to read and interpret technical documentation, data dictionaries, schema diagrams, and business requirements documents.</span></li> </ul> </td> </tr> <tr> <td style="width:6.65in;border:solid black 1.0pt;border-top:none;background-color:#d9d9d9;padding:0.0in 5.4pt 0.0in 5.4pt"> <p style="margin:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><strong><span style="font-size:11.0pt;color:black">Mathematical Skills:</span></strong></p> </td> </tr> <tr> <td style="width:6.65in;border:solid black 1.0pt;border-top:none;background-color:white;padding:0.0in 5.4pt 0.0in 5.4pt"> <ul style="margin-top:0.0in;margin-bottom:0.0in" type="disc"> <li style="margin-top:0.0in;margin-right:0.0in;margin-bottom:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><span style="font-size:11.0pt;color:black">Strong quantitative and analytical skills; ability to apply concepts of basic statistics, percentages, ratios, and proportions to practical business situations and to validate data accuracy across reporting solutions.</span></li> </ul> </td> </tr> <tr> <td style="width:6.65in;border:solid black 1.0pt;border-top:none;background-color:#d9d9d9;padding:0.0in 5.4pt 0.0in 5.4pt"> <p style="margin:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><strong><span style="font-size:11.0pt;color:black">Physical Requirements:</span></strong></p> </td> </tr> <tr> <td style="width:6.65in;border:solid black 1.0pt;border-top:none;background-color:white;padding:0.0in 5.4pt 0.0in 5.4pt"> <p style="margin:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"> </p> <p style="margin:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><span style="font-size:11.0pt;color:black">The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.</span></p> <p style="margin:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"> </p> <p style="margin:0.0in;font-size:12.0pt;font-family:'Times New Roman', serif"><span style="font-size:11.0pt;font-family:Arial, sans-serif;color:black">While performing the duties of this job, the employee is regularly required to sit, use hands to finger, handle, or feel; reach with hands and arms; and talk or hear. The employee frequently operates a computer and other standard office equipment for extended periods. The employee must occasionally lift and/or move up to <u>25</u> lbs. Specific vision abilities required for this job include close vision and the ability to focus on a computer screen for prolonged periods.</span></p> <p style="text-align:justify;margin:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"> </p> </td> </tr> <tr> <td style="width:6.65in;border:solid black 1.0pt;border-top:none;background-color:#d9d9d9;padding:0.0in 5.4pt 0.0in 5.4pt"> <p style="margin:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><strong><span style="font-size:11.0pt;color:black">Work Environment:</span></strong></p> </td> </tr> <tr> <td style="width:6.65in;border:solid black 1.0pt;border-top:none;background-color:white;padding:0.0in 5.4pt 0.0in 5.4pt" valign="top"> <p style="margin:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"> </p> <p style="margin:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><span style="font-size:11.0pt;color:black">The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.</span></p> <p style="margin:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"> </p> <p style="margin:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"><span style="font-size:11.0pt;color:black">This is an on-site position based in Frederick, MD. While performing the duties of this job, the employee is regularly exposed to a standard office environment. The noise level in the work environment is usually quiet to moderate. The employee may occasionally walk through the manufacturing area to support operational stakeholders, where higher noise levels and exposure to moving mechanical equipment may be encountered.</span></p> <p style="margin:0.0in;font-size:7.0pt;font-family:Arial, sans-serif"> </p> </td> </tr> </tbody> </table> <p> </p>