Job Closed

This listing is no longer active.

Senior SQL/ETL Developer

Analytics EngineerAnalytics EngineerFull TimeRemoteSeniorTeam 1,001-5,000Since 2020H1B No SponsorCompany SiteLinkedIn

Location

United States

Posted

70 days ago

Salary

0

Seniority

Senior

Bachelor Degree5 yrs expEnglishETLSQL

Job Description

Senior SQL/ETL Developer

Moder

• The Senior SQL ETL Developer is responsible for designing, developing, and maintaining SQL-based data integration and transformation processes that support reporting and analytics. • This role focuses on building and optimizing ETL pipelines, ensuring data accuracy and integrity, and supporting data models used across the organization. • Essential Job Duties include design, develop, and optimize T-SQL stored procedures, functions, and views for ETL and reporting use cases. • Build and maintain scalable ETL pipelines to ingest and transform data from multiple source systems. • Implement incremental loading strategies, change data capture, and historical tracking (Type 1 and Type 2). • Develop reusable SQL frameworks for data ingestion, transformation, and reconciliation. • Implement and maintain data quality checks including row counts, schema validation, null checks, and duplicate detection. • Perform source-to-target reconciliation and investigate discrepancies in data. • Ensure auditability and compliance through well-documented, traceable SQL logic. • Tune SQL queries and stored procedures for performance, efficiency, and scalability. • Support and enhance dimensional and relational data models used for reporting and analytics. • Collaborate with reporting and analytics teams to ensure data accuracy, consistency, and usability. • Analyze execution plans, indexing strategies, and query patterns to resolve performance bottlenecks. • Ensure ETL processes meet defined SLAs and execution windows. • Troubleshoot ETL failures, production issues, and data inconsistencies. • Implement and maintain logging, error handling, and restart/recovery mechanisms. • Participate in code reviews, release planning, and production deployments.

Job Requirements

  • Strong experience with T-SQL development (stored procedures, functions, views)
  • Hands-on experience building and maintaining ETL pipelines
  • Solid understanding of data warehousing concepts (fact/dimension models, SCDs)
  • Experience with performance tuning (execution plans, indexing, query optimization)
  • Knowledge of data quality, validation, and reconciliation techniques
  • Experience with incremental data loading and change tracking
  • Strong problem-solving skills and ability to troubleshoot complex data issues
  • Experience working in production environments with SLAs
  • Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field
  • 5-8+ years of experience in SQL development, data engineering, or ETL development
  • At least 3+ years working specifically with ETL pipelines and data warehousing concepts
  • Demonstrated experience in performance tuning and production support environments.

Benefits

  • Equal Employment Opportunity: The company is committed to providing equal employment opportunities to all employees and applicants without regard to race, ethnicity, color, sex, marital status, sexual orientation, gender identity or expression, pregnancy, religion, national origin, age (40 and over), disability, military status, genetic information, or any other basis protected by applicable federal, state, or local laws.
  • Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Related Categories

Related Job Pages

More Analytics Engineer Jobs

Air Methods logo

Sr Data Engineer

Air Methods

Elevating Critical Care

Full TimeRemoteTeam 1,001-5,000Since 1980H1B Sponsor

Overview Job Summary The Senior Data Engineer at Air Methods is responsible for leading and growing our data-driven decision culture by designing, developing, and delivering data engineering and analytical solutions that are customer focused, easy to consume and create business impact. To be successful, this teammate must have a passion for mentoring other data engineers and working with stakeholders to understand their needs and deliver value through the entire data pipeline. You will design and implement complex data models, model metadata, build data pipelines, reports and dashboards, and own data presentation and dashboarding tools for the end users of our data products and systems. You will write scalable, highly tuned SQL queries and will develop learning and training programs to drive adoption of data driven decision making across the organization. Essential Functions and Responsibilities include the following: - Develop and improve the current data architecture, emphasizing data security, data quality and timeliness, scalability, and extensibility - Develop and implement complex and efficient data pipelines/solutions to transform raw data sources into powerful, reliable components of our data platform and business insights - Deploy and use various data and big data technologies and run pilots to design low latency data architectures at scale - Implement and simplify self-service data query and analysis capabilities of the data platform - Establish and maintain standards and guidelines for design and development, tuning, deployment, and maintenance of information and advanced data analytics - Meet with subject matter experts in different areas of the business, be able to quickly learn the concepts and business language relevant to their line of business and develop an understanding of how their data supports their business processes - Actively mentor and lead knowledge sharing sessions, code, and design reviews - Build conceptual and logical data models for stakeholders and management - Actively lead knowledge sharing sessions, code, and design reviews - Support the data platform infrastructure and implement solutions to ensure continuous improvement in platform stability - Collaborate with business analysts, data scientists, product owners, software development engineers, and other teams to develop, implement, and validate KPIs, statistical analyses, data profiling, prediction, forecasting, clustering, and machine learning algorithms - Other duties as assigned Additional Job Requirements - This position is not eligible for sponsorship. - Regular scheduled attendance - Indicate the percentage of time spent traveling - 0% Subject to applicable laws and Air Method’s policies, regular attendance is an essential function of the position. All employees must follow Air Methods’ employment practices and policies. Supervisory Responsibilities This position has no supervisory responsibilities. Qualifications To perform this job successfully, an individual must be able to perform each essential function satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. In accordance with applicable laws, Air Methods will provide reasonable accommodations that do not create an undue burden so disabled employees may perform the essential functions of the position. Education & Experience - Bachelor’s degree (BS/BA) from four-year college or university in Information Computer Science or related field, and eight+ years’ related experience and/or training; or equivalent combination of education and experience - 10+ years in Data Engineering or related field - 5+ years working in a cloud computing environment, Azure preferred - Extensive experience in building scalable data platforms in a cloud data platform, Snowflake preferred - Extensive experience gathering data from multiple heterogeneous data sources, including databases, various file formats, and REST and SOAP APIs - Hands-on experience with Azure technologies, such as SQL and NoSQL databases, Azure DevOps, Azure Data Factory, Databricks, and Azure Analytics Services desired - Strong experience with Data Visualization Tools (Power BI preferred) - Strong experience in an Agile Scrum environment, with work estimation and providing input to managers on resource and risk planning Skills - Ability to lead and mentor other data engineers - Authoritative in ELT optimization, designing, coding, and tuning data processes - Experience with building data pipelines and applications to stream and process datasets at low latencies - Experience in data mining, profiling, and analysis - Experience with complex data modelling, ELT design, and using large databases in a business environment - Demonstrates efficiency in handling data - tracking data lineage, ensuring data quality, and improving discoverability of data - Affinity for learning modern technologies, data analysis, and identifying data patterns and trends - Proven ability to develop unconventional solutions; Sees opportunities to innovate and leads the way - Demonstrates high critical thinking and reasoning skills and strong attention to detail while working in a fast-paced environment that requires ability to prioritize and multi-task - Excellent communication skills, both written and verbal Computer Skills - Advanced experience with Microsoft Suite, including Word, Excel, PowerPoint, and Outlook - Experience modeling data in cloud data platforms such as Snowflake, Redshift, and or BigQuery - Experience with Python, Spark and PySpark desired - Expert in data architecture, ELT, and data ingestion development skills - Advanced proficiency in writing complex SQL statements and manipulating large structured and semi-structured datasets. - Experience with scheduling tools or a DAG scheduler - Experience with cloud warehouse ELT tools (e.g., Matillion, dbt) Certificates, Licenses, Registrations - None Air Methods is an EEO/AA employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. Minimum pay USD $124,000.00/Yr. Maximum Pay USD $158,000.00/Yr. Benefits For more information on our industry-leading benefits, please visit our benefits page here. Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)

United States
$124K - $158K / year
Thoughtworks logo

Senior DataOps Engineer

Thoughtworks

Thoughtworks is a dynamic and inclusive community of bright and supportive colleagues who are revolutionizing tech. As a leading technology consultancy, we’re pushing boundaries through our purposeful and impactful work. Over 30 years of delivering extraordinary impact with clients. Helping clients solve complex business problems with technology as the differentiator.

Full TimeRemoteTeam 10,001

Senior data engineers at Thoughtworks are engineers who build, maintain and test the software architecture and infrastructure for managing data applications. They are involved in developing core capabilities which include technical and functional data platforms. They are the anchor for functional streams of work and are accountable for timely delivery. They work on the latest big data tools, frameworks and offerings (data mesh, etc.), while also being involved in enabling credible and collaborative problem solving to execute on a strategy. Job responsibilities - You will develop and operate modern data architecture approaches to meet key business objectives and provide end-to-end data solutions. - You will develop intricate data processing pipelines, addressing clients' most challenging problems. - You will collaborate with data scientists to design scalable implementations of their models. - You will write clean, iterative code using TDD and leverage various continuous delivery practices to deploy, support and operate data pipelines. - You will use different distributed storage and computing technologies from the plethora of options available. - You will develop data models by selecting from a variety of modeling techniques and implementing the chosen data model using the appropriate technology stack. - You will collaborate with the team on the areas of data governance, data security and data privacy. - You will incorporate data quality into your day-to-day work. Job qualifications Technical Skills - Working with data excites you: you can build and operate data pipelines, and maintain data storage, all within distributed systems. - You have hands-on experience of data modeling and modern data engineering tools and platforms. - You have experience in writing clean, high-quality code using the preferred programming language. - You have built and deployed large-scale data pipelines and data-centric applications using any of the distributed storage platforms and distributed processing platforms in a production setting. - You have experience with data visualization techniques and can communicate the insights as per the audience. - You have experience with data-driven approaches and can apply data security and privacy strategy to solve business problems. - You have experience with different types of databases (i.e.: SQL, NoSQL, data lake, data schemas, etc.). - Experience with Azure Synapse and Azure Data Factory for enterprise data movement and ETL/ELT pipelines, and Azure Databricks and Azure Data Lake Gen2. - Experience with Azure Machine Learning and Azure AI Services (including Azure OpenAI, AI Search, Document Intelligence, and Language). Professional Skills - Experience integrating systems with Splunk for security logging and monitoring, and ServiceNow for IT Service Management (ITSM) and configuration item management. - Ability to provide both Tier-2/3 platform O&M (Operations & Maintenance) and application-level data engineering support for business initiatives. - You understand the importance of stakeholder management and can easily liaise between clients and other key stakeholders throughout projects, ensuring buy-in and gaining trust along the way. - You are resilient in ambiguous situations and can adapt your role to approach challenges from multiple perspectives. - You don’t shy away from risks or conflicts, instead you take them on and skillfully manage them. - You are eager to coach, mentor and motivate others and you aspire to influence teammates to take positive action and accountability for their work. - You enjoy influencing others and always advocate for technical excellence while being open to change when needed. Other things to know Learning & Development There is no one-size-fits-all career path at Thoughtworks: however you want to develop your career is entirely up to you. But we also balance autonomy with the strength of our cultivation culture. This means your career is supported by interactive tools, numerous development programs and teammates who want to help you grow. We see value in helping each other be our best and that extends to empowering our employees in their career journeys. Extra important information EEO Statement - Thoughtworks is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, ancestry, veteran status, or any other protected class. - As a federal contractor, Thoughtworks is an affirmative action employer of protected veterans and individuals with disabilities. Accommodations - Thoughtworks is committed to providing reasonable accommodations to applicants with disabilities and to applicants with sincerely held religious beliefs throughout the hiring process. If you need an accommodation to apply or participate in the interview process, please complete this form or speak with your recruiter. US - Work Authorization - Applicants for employment in the US must have work authorization that does not now or in the future require sponsorship of a visa for employment in the United States. Responsible Use of AI in Recruitment At Thoughtworks, we use AI tools to support our recruitment team with administrative tasks such as drafting communications, scheduling interviews and writing job descriptions. Crucially, our AI tools do not screen, assess, rank or make hiring decisions. Every application is reviewed by our team and all selection decisions are made exclusively by our interviewers and hiring managers. We are committed to fairness and responsible AI. We actively manage our AI systems by testing, monitoring for biased outcomes and implementing mitigation measures. We hold our third-party vendors to these same high standards through a rigorous governance process. For additional information, please see our full Thoughtworks AI Policy for Recruitment. About Thoughtworks Thoughtworks is a dynamic and inclusive community of bright and supportive colleagues who are revolutionizing tech. As a leading technology consultancy, we’re pushing boundaries through our purposeful and impactful work. For 30+ years, we’ve delivered extraordinary impact together with our clients by helping them solve complex business problems with technology as the differentiator. Bring your brilliant expertise and commitment for continuous learning to Thoughtworks. Together, let’s be extraordinary. #LI-Remote Salary Benefits: https://www.thoughtworks.com/en-us/careers/benefits The annual salary range posted is subject to many factors and may vary depending on experience, geographic location, job responsibilities, performance, skills and/or training. Salary $148,000—$223,000 USD See here our AI policy.

United States
$148K - $223K / year
Job Closed
Mindrift logo

Freelance Junior Journalist - AI Trainer

Mindrift

Apply → Pass qualification(s) → Join a project → Complete tasks → Get paid. Project time expectations: Tasks are estimated to require around 10–20 hours per week during active phases, based on project requirements; This is an estimate, not a guaranteed workload, and applies only while the project is active. Note: Rates vary based on expertise, skills assessment, location, project needs, and other factors. Higher rates may be offered to highly specialized experts. Lower rates may apply during onboarding or non-core project phases. Payment details are shared per project.

Please submit your resume in English and indicate your level of English proficiency. Mindrift connects specialists with project-based AI opportunities for leading tech companies, focused on testing, evaluating, and improving AI systems. Participation isproject-based, not permanent employment. What this opportunity involves As an AI Trainer - Junior Journalist, your work will help train AI models, shaping how they understand and generate human-like text. This isn’t just traditional writing—you’ll be crafting text that teaches AI reasoning, logic accuracy, nuance, and clarity. While each project involves unique tasks, contributors may: - Craft original, clear, and fact-checked responses based on project guidelines. - Generate prompts that challenge AI. - Define comprehensive scoring criteria to evaluate the accuracy of the AI’s answers. - Follow style and quality standards to ensure consistency. What we look for This opportunity is a good fit if you are seeking for open to part-time, non-permanent projects. Ideally, contributors will have:  - Bachelor’s degree in Journalism, Communications, Linguistics, Literature, or Education to ensure a strong understanding of grammar and stylistic features; - At least 1 year of professional experience in Journalism, Communications, PR, etc., with strong skills in critical thinking and working with text in English language; - Strong written English (C1/C2); - Stable internet connection.  How it works Apply → Pass qualification(s) → Join a project → Complete tasks → Get paid Project time expectations For this project, tasks are estimated to require around 10–20 hours per week during active phases, based on project requirements. This is an estimate, not a guaranteed workload, and applies only while the project is active. Compensation On this project, contributors can earn up to $30 per hour equivalent, depending on their level and pace of contribution. Compensation varies across projects depending on scope, complexity, and required expertise. Please note that other projects on the platform may offer different earning levels based on their requirements.

Colorado
Job Closed
Mindrift logo

Freelance Junior Journalist - AI Trainer

Mindrift

Apply → Pass qualification(s) → Join a project → Complete tasks → Get paid. Project time expectations: Tasks are estimated to require around 10–20 hours per week during active phases, based on project requirements; This is an estimate, not a guaranteed workload, and applies only while the project is active. Note: Rates vary based on expertise, skills assessment, location, project needs, and other factors. Higher rates may be offered to highly specialized experts. Lower rates may apply during onboarding or non-core project phases. Payment details are shared per project.

Please submit your resume in English and indicate your level of English proficiency. Mindrift connects specialists with project-based AI opportunities for leading tech companies, focused on testing, evaluating, and improving AI systems. Participation isproject-based, not permanent employment. What this opportunity involves As an AI Trainer - Junior Journalist, your work will help train AI models, shaping how they understand and generate human-like text. This isn’t just traditional writing—you’ll be crafting text that teaches AI reasoning, logic accuracy, nuance, and clarity. While each project involves unique tasks, contributors may: - Craft original, clear, and fact-checked responses based on project guidelines. - Generate prompts that challenge AI. - Define comprehensive scoring criteria to evaluate the accuracy of the AI’s answers. - Follow style and quality standards to ensure consistency. What we look for This opportunity is a good fit if you are seeking for open to part-time, non-permanent projects. Ideally, contributors will have:  - Bachelor’s degree in Journalism, Communications, Linguistics, Literature, or Education to ensure a strong understanding of grammar and stylistic features; - At least 1 year of professional experience in Journalism, Communications, PR, etc., with strong skills in critical thinking and working with text in English language; - Strong written English (C1/C2); - Stable internet connection.  How it works Apply → Pass qualification(s) → Join a project → Complete tasks → Get paid Project time expectations For this project, tasks are estimated to require around 10–20 hours per week during active phases, based on project requirements. This is an estimate, not a guaranteed workload, and applies only while the project is active. Compensation On this project, contributors can earn up to $30 per hour equivalent, depending on their level and pace of contribution. Compensation varies across projects depending on scope, complexity, and required expertise. Please note that other projects on the platform may offer different earning levels based on their requirements.

United States
Job Closed