Analytics Engineer - Post Sales (Madison, WI - Hybrid)

At TruStage, we’re on a mission to make a brighter financial future accessible to everyone.  We put people first, and work hand in hand with employees and customers to create a diverse and inclusive environment. Passionate about building insurance and financial services solutions, we push the boundaries of what’s possible. We need you to help us shape what’s next. You’ll be encouraged to share your experiences, ideas and skills to help others take control of their financial future.

Join a team that has received numerous awards for being a top place to work: TruStage awards and recognition

Job Responsibilities:
 

Data Pipelines

• Design, implement, and maintain scalable ETL/ELT data pipelines using tools such as Alteryx, Azure Data Factory, or similar to optimize data processing efficiency.
• Optimize data ingestion processes into data warehousing solutions such as Snowflake, ensuring accuracy, reliability, and consistency across multiple sources.

Data Models

• Develop and maintain dimensional data models in data warehousing solutions like Snowflake for analytical and reporting purposes by integrating multiple data sources to provide actionable insights.
• Implement data transformations and aggregation techniques to support complex analytical queries, Data Science needs, processes, and improve reporting and query performance.

Data Quality

• Establish automated data validation scripts and monitoring processes to reduce anomalies and maintain consistent high data integrity standards.
• Implement corrective actions to ensure continued accuracy and reliability of data across platforms.

Collaboration

• Collaborate with cross-functional teams to gather requirements and translate business objectives into technical solutions.
• Facilitate knowledge sharing on best practices for tools and data to foster a data-driven culture within the team.

Documentation

• Document data pipelines, data models, and technical specifications involving all workflows, schemas, and scripts to ensure clarity and reproducibility of data processes.
• Maintain comprehensive documentation on data lineage and metadata to support data governance requirements and team data tracking requirements.

Maintenance and Support

• Provide ongoing support for data pipelines, data models, and analytical systems under supervision.
• Implement proactive alerting and monitoring mechanisms to identify and resolve data processing issues in a timely manner.

Performance Optimization

• Continuously evaluate and improve data processes and architectures to enhance performance and scalability.
• Implement best practices for data management and optimization, including indexing, partitioning, and query optimization.

Data Compliance

• Ensure data usage adheres to established Data Governance best practices, including any requirements for data encryption and regulatory and audit purposes.

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.
• 4+ years of experience in analytics engineering, data engineering, or related field.
• Strong proficiency in SQL, Python, and R; familiarity with Snowflake, Alteryx, and Azure; understanding of version control and business intelligence tools.
• Advanced understanding of database design, data modeling, and data quality assurance.
• Strong analytical and problem-solving skills.
• Strong communication, documentation, organizational, and project management skills.

Work Authorization/Sponsorship

At this time, we're not considering applicants that need any type of immigration sponsorship (additional work authorization or permanent work authorization) now or in the future to work in the United States. This includes, but IS NOT LIMITED TO: F1-OPT, F1-CPT, H-1B, TN, L-1, J-1, etc.

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.

Accommodation request

TruStage is a place where everyone can bring their best self and thrive. If you need application or interview process accommodations, please contact the accessibility department.