Job Responsibilities:

Data Pipelines

• Lead the design and optimization of complex ETL/ELT pipelines using tools such as Alteryx, Azure Data Factory, or similar.
• Ensure data ingestion processes into data warehousing solutions like Snowflake are accurate, reliable, and consistent.
• Mentor junior engineers in best practices for data pipeline development.

Data Models

• Lead the creation and maintenance of advanced dimensional data models in data warehousing solutions.
• Integrate multiple complex data sources to provide actionable insights and support analytical queries, processes, Data Science needs, and improve reporting performance.
• Implement advanced data transformations and aggregation techniques.

Data Quality

• Develop comprehensive data quality frameworks and automated validation processes.
• Implement advanced techniques for anomaly detection and correction.
• Ensure consistent high data integrity standards across platforms.

Collaboration

• Lead cross-functional collaboration to gather requirements and translate business objectives into technical solutions.
• Facilitate knowledge sharing on best practices for tools and data.
• Foster effective communication between teams.

Documentation

• Ensure comprehensive documentation of data pipelines, data models, and technical specifications.
• Maintain detailed documentation for complex data processes.
• Support data governance requirements through accurate data lineage and metadata documentation.

Maintenance and Support

• Lead ongoing support for data pipelines, data models, and analytical systems.
• Develop proactive monitoring solutions to identify and resolve data processing issues.
• Ensure system reliability and performance.

Performance Optimization

• Lead optimization efforts for complex data architectures.
• Implement advanced techniques for data management and optimization, including indexing, partitioning, and query optimization.
• Continuously evaluate and improve data processes and architectures.

Data Compliance

• Lead compliance efforts, ensuring adherence to established Data Governance best practices.
• Mentor junior staff on best practices for data compliance.
• Ensure data usage meets regulatory and audit requirements.

Leadership

• Develop leadership skills and manage small to mid-size team projects.
• Mentor junior team members and foster a collaborative environment.

The above statement of duties is not intended to be all inclusive and other duties will be assigned from time to time.

Job Requirements:

• Bachelor’s degree in computer science, economics, statistics, information management, engineering, or related field, or equivalent combination of education and/or related professional work experience.
• 6+ years of experience in analytics engineering, data engineering, or related field.
• Strong proficiency in SQL, Python, and R; extensive experience with Snowflake, Alteryx, Azure, Git and business intelligence tools.
• Advanced understanding of database design, data modeling, and data quality assurance.
• Strong analytical and problem-solving skills.
• Excellent communication, documentation, organizational, and project management skills.
• Ability to manage small project teams and provide mentorship to junior members.

If you’re ready to help make a difference, apply today.A resume is required to apply. TruStage may process applicant information using an Artificial Intelligence (AI) tool.  This tool automatically generates a screening score based on how well applicant information matches the requirements and qualifications for the position. TruStage recruiters use the screening score as a guide to further evaluate candidates; the score is one component of an application review and does not automatically determine whether a candidate moves forward.  Candidates may choose to opt out of this process.

Compensation may vary based on the job level, your geographic work location, position incentive plan and exemption status.

Base Salary Range:

At TruStage, we believe a sound, inclusive benefits program is of vital importance, along with a flexible workplace that allows for work-life balance, career growth and retirement assistance. In addition to your base pay, your position may be eligible for an annual incentive (bonus) plan.  Additional benefits available to eligible employees include medical, dental, vision, employee assistance program, life insurance, disability plans, parental leave, paid time off, 401k, and tuition reimbursement, just to name a few. Beyond pay and benefits, we also recognize that flexibility, including working in a place you prefer, is essential to caring for our employees.  We will continue to strive to offer flexibility and invest in technology and other tools that will make hybrid working normal rather than an exception, so that when “life happens,” you can focus on what’s most important.