Somerset
Job Description Data Engineer Reports to: Director of Application Services FLSA Status: Non-Exempt About CompoSecure Founded in 2000, CompoSecure (Nasdaq: CMPO) is a technology partner to market leaders, fintechs and consumers, enabling trust for millions of people around the globe. The company combines elegance, simplicity, and security to deliver exceptional experiences and peace of mind in the physical and digital world. CompoSecure's innovative payment card technology and metal cards with Arculus security and authentication capabilities deliver unique, premium branded experiences, enable people to access and use their financial and digital assets, and ensure trust at the point of a transaction. For more information, please visit and . Position Overview: The Data Engineer is responsible for designing, building, and maintaining robust data pipelines and solutions to support business analytics and reporting. This role focuses on leveraging Microsoft Azure, Microsoft Fabric, PySpark, SQL, APIs, and ETL processes to ensure efficient, secure, and high-quality data delivery for enterprise analytics platforms such as Power BI. The Data Engineer will work fully on site, collaborating closely with cross-functional teams to drive data efficiency and innovation. Key Responsibilities: Data Engineering & Pipeline Development • Design, develop, and maintain data pipelines using Azure Data Factory, Azure Synapse, and Microsoft Fabric Dataflows., • Implement and maintain Medallion architecture in Fabric and Azure environments., • Build ingestion and transformation flows that efficiently convert raw Parquet files into Delta tables to support curated, incremental, and governed datasets optimized for Power bi., • Implement efficient data lakehouse patterns within Microsoft Fabric. Data Modeling & Optimization • Design and maintain star schemas, dimensional models, and semantic layers for Power Bi., • Collaborate with Power Bi developers to ensure models are performant and aligned to needs., • Tune queries, optimize partitioning, and manage performance across Fabric and Synapse environments. Cloud Data Architecture & Governance • Ensure solutions follow Azure best practices for scalability, cost efficiency, and security., • Implement data governance, lineage, and cataloging via Microsoft Purview and Fabric capabilities., • Partner with IT security and compliance teams to enforce data access controls. Routine IT Functions • Handles all Help Desk tickets related to reporting., • Handles related email and telephone correspondence in a timely and professional manner., • Responds to inquiries for the purpose of resolving problems, providing information and/or referring to appropriate personnel., • Minimum 5 years of relevant experience., • Strong expertise in data languages (Python, SQL, DAX, M, R, etc.) and handling large data sets using PySpark., • Strong expertise in Azure Data Factory, Azure Synapse Analytics, Databricks (nice-to-have), and Microsoft Fabric., • Hands-on experience implementing Medallion architecture in a lakehouse environment., • Expertise in transforming Parquet datasets into Delta tables for reliable, incremental processing., • Experience building ETL/ELT pipelines and working with both structured and unstructured data., • Familiarity with CI/CD for data pipelines a plus., • Experience with Power BI integration and data modeling., • Excellent analytical and problem-solving skills., • Excellent record keeping and auditing skills., • Excellent communication skills, both oral and written., • Strong attention to detail and ability to self-check work., • Excellent time management skills., • Task oriented excellent organizational skills, ability to prioritize workload., • Must be able to work beyond 40 hour week during upgrades or new functionality rollout if necessary., • Must be able to work flex schedule. Weekends and late hours or staggered shifts., • Must have valid driver's license and personal vehicle., • Must be able to lift 50 lbs., • Must be able to sustain office work for 8+ hours per day including the following:, • Sitting in an office chair, • Typing, • Reaching for the telephone, • Standing at office equipment, • Hearing for phone use, • Sight for computer use, • Medical, Dental & Vision Coverage, • Flexible Spending Accounts (FSA), • Company-Paid Life and Disability Insurance, • 401(k) with Company Match, • Paid Time Off & Paid Holidays, • Annual Bonus Opportunities, • Employee Assistance Program (EAP), • Career Advancement Opportunities Benefits eligibility and details will be shared during the hiring process. We're excited to support you in building a rewarding career with us. Please note: CompoSecure does not accept unsolicited resumes from staffing agencies or third-party recruiters. Any unsolicited resumes sent to CompoSecure, including to our employees, will become the property of CompoSecure and may be used without any obligation to pay referral or placement fees. Any agency or recruiter seeking to work with CompoSecure's Talent Acquisition Team should contact our team directly by sending an email to . CompoSecure is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, or national origin. We are also an equal opportunity employer of individuals with disabilities and protected veterans.