Data Engineer

This position is responsible for designing, developing, and maintaining robust data solutions to support business operations and decision-making processes. This role involves working with cutting-edge technologies, including Microsoft Azure Cloud, Snowflake, and Power BI, to build and manage data lakes, data warehouses, and reporting systems. The Database Engineer ensures data accuracy, system reliability, and high-quality deliverables by performing thorough quality assurance testing and providing user support.

Collaboration with IT and business teams is essential to identify opportunities for operational efficiency and align data solutions with organizational goals. Reports to the Director, Data Analytics

All candidates should make sure to read the following job description and information carefully before applying.

Experience is Everything.

At LCS, experience is everything. We provide you the opportunity to use your talents in a progressive, growing organization that makes a positive difference in the lives of the seniors we serve. If you are seeking an organization that gives back, you’ll love working here. Our principles and hospitality promises define our company culture. LCS employees can be found participating in volunteer activities, getting involved in our committees or collaborating with team members in our innovative workspace.

You’ll find several opportunities to grow as a professional, serve the community, and enhance the lives of seniors.

What You’ll Do:

Design, develop, and maintain scalable data lakes, data warehouses, and data storage solutions.

Create and optimize ETL/ELT pipelines for efficient data processing and integration.

Implement data models to support reporting, analytics, and operational workflows.

Build, manage, and enhance Power BI dashboards and reports for actionable insights.

Collaborate with business stakeholders to gather reporting requirements and ensure data accuracy.

Leverage Microsoft Azure Cloud services (e.g., Data Factory, Synapse Analytics, Data Lake Storage) for data integration and processing.

Utilize Snowflake to manage and optimize data warehouse performance.

Perform thorough QA testing to ensure data accuracy, system reliability, and high performance.

Provide user support and troubleshoot issues with data systems, pipelines, and reporting tools.

Work closely with cross-functional teams to align data solutions with organizational objectives.

Identify and implement operational efficiencies in data workflows and system designs.

Ensure compliance with data governance, privacy, and security standards.

Follow best practices for version control, documentation, and CI/CD processes.

Stay updated on emerging technologies and trends to enhance data strategies and tools.

Recommend improvements to existing data processes and tools to drive innovation.

What We’re Looking For:

Required qualifications
Bachelor's year degree in Computer Science, MIS, or equivalent work experience.
2-4 years of experience in developing, implementing, and supporting enterprise solutions.

Experience with database concepts, advanced SQL, and reporting/Business Intelligence software.
Expertise in data architecture, data modeling, and building scalable data solutions.
Proficiency with Microsoft Azure Cloud services (e.g., Azure Data Factory, Synapse Analytics, Data Lake Storage).
Strong experience with Snowflake for data warehousing and optimization.
Advanced skills in Power BI for creating reports, dashboards, and data visualizations.
Proficient in SQL and scripting languages like Python for data integration and analysis.
Solid understanding of ETL/ELT pipelines and data integration workflows.
Strong problem-solving skills and attention to detail for troubleshooting data systems.
Excellent communication and collaboration abilities to work effectively across teams.

Why Join Us?

Industry Leader.
Inclusive & collaborative culture.
Top Workplace USA.
Top Workplace Iowa.
Charity and community involvement.
Outstanding advancement opportunities.
Ongoing career development.

Benefits

Competitive pay, great benefits and vacation time. We are an equal opportunity employer with benefits including medical, dental, life insurance,…