Senior Engineer - Data
hace 2 días
Irving
Job Description Summary: We are seeking a highly skilled and motivated Senior Engineer to oversee our data engineering initiatives. This role requires a deep understanding of data engineering principles, cloud technologies, and the ability to translate business requirements into robust and scalable technical solutions. The ideal candidate will be a hands-on leader, capable of both strategic thinking and technical execution, with a passion for fostering a collaborative and high-performing team. Responsibilities: Technical Strategy and Architecture: • Define and maintain the technical vision, architecture and future updates to our data platform within Microsoft Azure., • Lead the design and implementation of scalable and efficient data pipelines using Dagster., • Establish best practices for data modeling, data warehousing, and data lake strategies within Azure and SQL Server., • Evaluate and recommend new technologies and tools to enhance our data capabilities., • Ensure the security, reliability, and performance of our data infrastructure. Team Leadership and Mentorship: • Provide Technical Leadership and guidance to a team of Data Engineers, Developers and Analysts., • Mentor team members on best practices, technical skills, and career development., • Foster a collaborative and innovative team environment., • Conduct performance reviews and provide constructive feedback. SQL Server Database Management: • Possess strong knowledge of SQL Server database design, development, and administration, with experience in integrating SQL Server with other systems within and outside of Azure., • Optimize SQL queries and database performance, particularly in the context of data integration processes., • Identify areas for improvement by targeting long-running queries and high resource consumption within our production environment., • Ensure data integrity, security, and availability within SQL Server environments that participate in broader data integration strategies. Data Pipeline Development and Integration: • Oversee the development and maintenance of complex data pipelines using Dagster for seamless data integration from various sources., • Ensure the reliability, efficiency, and scalability of Dagster pipelines., • Troubleshoot and resolve issues related to data pipeline performance and data quality., • Implement monitoring and alerting for data pipeline health. Microsoft Fabric and Azure Expertise: • Leverage a deep understanding of Microsoft Fabric and Azure data services (e.g., Azure Data Factory, Azure Synapse Analytics, Azure Blob Storage, Azure SQL Database, Azure Databricks) to build and optimize data solutions., • Design and implement data solutions that are cost-effective and aligned with Azure and SDLC best practices., • Stay up-to-date with the latest Azure data platform developments. Power BI Reporting and Analytics: • Ensure data accuracy and performance of Power BI solutions by working with the Business Intelligence team to create seamless data integrations., • Optimize Power BI data models and DAX queries for performance. Python Scripting and Automation: • Utilize Python for data manipulation, automation of data-related tasks, and integration with various data platforms and APIs, including those of external systems., • Develop and maintain Python scripts for data extraction, transformation, and loading (ETL/ELT) processes that facilitate integration across different systems., • Implement automated testing for Python-based data solutions involved in data integration. Collaboration and Communication: • Collaborate effectively with other departments, including Business Intelligence, Analytics, and Engineering teams, to understand data needs and deliver integrated data solutions.Senior Engineer, • Communicate technical concepts clearly and effectively to both technical and non-technical stakeholders, especially regarding the complexities of data integration., • Participate in project planning and provide technical input, particularly concerning data integration strategies and challenges., • Document technical designs, processes, and solutions, with a strong emphasis on data integration workflows and dependencies., • Communicate regularly with the Director of Data to ensure alignment on key objectives and deliverables. Job Requirements: Experience: • 5 - 7 years of relevant industry specific experience with at least 1 - 2 years in a formal leadership position or tech lead role. Preferred Qualifications: • Bachelor's or Master's degree in Computer Science, Data Science, Information Technology, or a related field., • Proven experience in a Technical Leadership role, guiding and mentoring data professionals., • Solid knowledge of SQL Server database design, development, and performance tuning, including writing complex SQL queries and stored procedures., • Extensive hands-on experience with Microsoft Azure and Microsoft Fabric data services, including but not limited to Azure Data Factory, Azure Synapse Analytics, Azure Blob Storage, and Azure SQL Databases and Lakehouses., • Strong proficiency in developing and managing data pipelines using Dagster or similar orchestration tools (e.g., Apache Airflow)., • Deep understanding of data modeling concepts (e.g., relational, dimensional), data warehousing principles, and data lake architectures., • Strong programming skills in Python, with experience in data manipulation libraries (e.g., Pandas, NumPy) and automation., • Experience with version control systems (e.g., Git)., • Excellent problem-solving, analytical, and communication skills., • Ability to work independently and as part of a team in a fast-paced environment., • Ability to handle multiple projects simultaneously with competing deadlines. Nice To Have Qualifications: • Experience with Snowflake, Google Big Query, AlloyDB and other Database Management Systems., • Experience with other cloud platforms (e.g., AWS, Google Cloud)., • Familiarity with data science concepts and machine learning workflows., • Experience with CI/CD pipelines for data solutions., • Knowledge of data security best practices and compliance standards., • Azure certifications (e.g., Azure Data Engineer Associate, Azure Solutions Architect Expert). Why Moxie? We’re not just a pest control company—we’re a team that believes in doing the right thing, being kind, and constantly improving. At Moxie, you’ll be part of a supportive, high-energy culture with tons of room to grow! Here’s What We Offer • Award-winning workplace – Named a Top Place to Work since 2021, • Comprehensive benefits – Medical, dental, vision, and more, • 401(k) & Roth IRA – Because your future matters, • Paid Time Off – Work-life balance is important to us!, • Monthly company events & recognition programs, • Service projects – Be part of something bigger than just a job, • Pet insurance – Because furry family members deserve care too, • Wellness program – Prioritize your mental and physical well-being, • Previ – Exclusive employee perks including cellular discounts and up to 40% off gear from top lifestyle and tech brands, • Maternity Leave – Paid time off to support you during this important life moment Ready to Join the Moxie Family? If you’re looking for a fun, rewarding career where you can make an impact, grow professionally, and be part of an amazing team, we want to hear from you!