Christensen Associates has an exciting opportunity for a full-time Senior Data Engineer in our Madison, Wisconsin office.This newly-created role is ideal for a highly skilled and versatile data professional with extensive expertise in data engineering, architecture, and database administration. As both a strategic and hands-on contributor, you'll play a key role in designing, developing, and optimizing our data infrastructure—starting with building and implementing a database management system from the ground up to support the needs of our largest client. This position blends architectural leadership with hands on development. You'll build and maintain scalable and reliable data systems, guide key technical decisions that require creative and innovative solutions, manage projects, mentor team members, support client needs, and help shape the future of our internal data ecosystem.
Key Responsibilities :
- Build and optimize scalable data pipelines using modern data engineering tools and frameworks to support efficient ingestion, transformation, and delivery across diverse systems.
- Clean, validate, and structure raw data from external sources addressing inconsistencies and formatting issues to ensure accuracy and reliability.
- Design and maintain data workflows for large-scale datasets, optimizing query performance and reducing runtimes to support complex transformations, with solutions built to accommodate future growth in data volume and complexity.
- Recommend and manage appropriate storage solutions based on business needs and data architecture requirements.
- Design and implement scalable data models that adapt to evolving business needs.
- Implement secure data architecture practices to protect the confidentiality, integrity, and availability of client data and ensure compliance with client data protection agreements.
- Build architecture with a strong emphasis on data quality, incorporating automated testing and validation to proactively detect and reduce pipeline errors, ensure data integrity, and enhance reliability.
- Design and maintain data architecture that promotes consistency and integration across datasets and teams.
Database Administration
Administer and monitor large-scale databases to ensure performance and reliability.Implement replication, recovery, and node scaling strategies.Manage user roles and access permissions.Optimize database performance through query tuning, indexing strategies, partitioning, and caching to support analytical workloads.Team & Project Support
Manage multiple projects and priorities in a client-focused environment, meeting tight deadlines while maintaining high standards of quality, communication, and responsiveness.Collaborate with data analysts, client stakeholders, and company leadership to improve data workflows, provide guidance, mentorship, and training, and drive continuous improvement in data practices.Qualifications :
Bachelor's degree in Information Systems, Computer Science, Data Science, or a related field.7+ years of relevant data engineering, data architecture, and database administration experience.Proven track record designing and managing large-scale databases and datasets.Hands-on experience with database platforms (e.g., ClickHouse, SQL Server, Teradata).Understands analytical database environments (OLAP), distributed computing, and performance tuning.Skilled in designing and maintaining ETL / ELT workflows, administering production databases, and leading technical projects / resources.Advanced proficiency in SQL, Python, and Excel. Strong capabilities in query development, performance optimization, and scripting. Skilled in writing complex SQL queries, stored procedures, and functions, as well as leveraging Python libraries such as Pandas and SQLAlchemy for data manipulation and analysis.Familiarity with CI / CD practices.Strong analytical, problem-solving, and communication skills, with the ability to engage both technical and non-technical audiences.Able to work independently and collaboratively in a deadline-driven environment.Experience in logistics or shipping industries is a plus.Candidates must be legally authorized to work in the U.S. for any employer. We are unable to sponsor individuals for a work visa or other employment authorization at time of hire or in the future (e.g., H-1B, green card, etc.).Successful completion of a federal security clearance including drug screen and background check is required.Candidates must be willing and able to work in our Madison, Wisconsin office. This is not a remote position.Why you should join the team :
Career growth. You will work with (and be mentored by) some of the best and brightest individuals in the industry. You will be part of a firm that solves complex, real-world business, data, and microeconomic problems using creativity, your rigorous academic training / experience, and the deep institutional knowledge of your Christensen Associates' team members.Positive work environment. We firmly believe that being a great place to work is a prerequisite to producing great work. That's why we're invested in making our company culture as engaging and rewarding as possible. We are not your typical consulting firm. We are employee-owned. There is little travel. Everyone receives a private office and underground parking. We believe in working hard and enjoying life outside of work. That's why we offer flexible schedules and comp time for hours worked over 40.Competitive compensation and benefits package. We offer a competitive total rewards package with health, dental, vision, life / AD&D, and long-term disability insurance as well as a 401k and Employee Stock Ownership Plan with generous company contributions. In addition, you will receive paid holidays, vacation, sick, and personal time.J-18808-Ljbffr