2024-04-05 McCarthy Building Companies, Inc.
Other
/yr
employee
contract
St. Louis Missouri 63101 United States
McCarthy Building Companies, Inc.
McCarthy is seeking a full-time Data Engineer located in St. Louis, MO who, as part of the Enterprise Solutions and Analytics team, will play a crucial part in shaping our data infrastructure, supporting our existing systems, and driving innovation through ML and AI solutions. As we expand our capabilities, your expertise will be pivotal in delivering end-to-end data pipelines and repositories.
Key Responsibilities
Profile source system data and design data warehouse and lake schemas
Design, implement, and support ETL and ELT pipelines
Create and run testing protocols for data solutions
Collaborate with cross-functional teams to identify ML and AI opportunities within our data ecosystem.
Design, implement, and optimize ML models and algorithms.
Deploy ML solutions into production, ensuring scalability and reliability.
Assure development work accords with best practices including security, quality control, and version control
Participate in code and design review to ensure alignment to standards and best practices
Research, analyze, recommend, and select technical approaches for solving challenging and complex development and integration problems
Skills & Qualifications
3+ years of data solution delivery experience (some experience in the azure data environment is preferred)
Experience with T-SQL (queries, stored procedures, and DDL)
Experience querying API endpoints
Experience with Power Query
Solid understanding of data warehouse and data lake concepts and design (including star schemas)
Experience with Agile/Scrum methodology preferred
Excellent analytical, conceptual, and problem-solving abilities with aptitude for acquiring new technical skills
Entrepreneurial attitude with a passion to deliver value for the organization
Highly motivated team player with strong interpersonal skills
Constant learner with a passion for continuous growth and improvement
Python proficiency for ML and AI development.
Nice to Haves
Experience on the Microsoft Azure platform including Azure Data Factory (pipelines and mapping & wrangling data flows), Azure SQL, Azure Data Lake Gen2, Azure DevOps
Experience developing and promoting work through devops/dataops pipelines and utilizing source control
Experience building data pipelines to ingest unstructured and streaming data
Experience preparing data for Data Science and Machine Learning use cases
Experience with master data management
Experience designing reports using Power BI, Power Query, and DAX
McCarthy Building Companies is proud to be an equal opportunity and affirmative action employer regardless of race, color, gender, age, sexual orientation, gender identity, gender expression, religious beliefs, marital status, genetic information, national origin, disability, protected veteran status, or any other basis protected by federal, state, or local law.