Secure. Modernize. Optimize.
ETL Developer
Location
United States
Posted
1 day ago
Salary
$92K - $128K / year
Seniority
Senior
Job Description
ETL Developer
PingWind Inc. (SDVOSB)
• Serve as the ETL Developer supporting sustainment services for VA, migration of large-scale systems to the cloud, and delivery of advanced analytics, including Artificial Intelligence (AI) capabilities • Responsible for overall technical execution of all activities performed by the ETL Developers who are matrixed into Scrum Teams • Design robust ETL processes that facilitate seamless data integration from multiple sources into applications or the data warehouse • Coordinate across workstreams to ensure Scrum teams are properly staffed with the necessary resources • Peer review code written by other ETL Developers • Ensure all team members are trained on best practices and common coding guidelines, promoting knowledge sharing across the team • Perform a robust set of data integrity operations/checks throughout the ETL process (quality control, unit testing, functional testing, and system testing) • Ensure SQL validation scripts are run daily to check the status and data integrity of the overnight ETL jobs • Track the efficiency and performance of all automated processes to verify they are operating within defined timelines/service levels and they are producing high-quality/valid reports with traceability of data used to generate each report • Develop and validate ETL workflows and store the resulting ETL packages in GitHub • Track, by manual and automated means (i.e., triggers on sensing/logging systems), any notable deviations from target thresholds on availability, server load, disc I/O rates, etc. • Ensure solutions are appropriately configured, available, and accessible for users
Job Requirements
- Bachelor's Degree in computer science, engineering or technical discipline
- 5 years relevant experience.
- Proficient working with SharePoint, Microsoft Teams, PowerApps, and Power BI
- Proficient with Microsoft SSIS ETL Tools
- Proficient with Microsoft SQL Server
- Outstanding written and verbal communication skills
- Expert communication and client management skills
- Self-motivated, detail-oriented, and organized
- Strong research, analytical, and problem-solving skills
- Flexible, able to adapt to different customer groups and expectations
- Experience working in and with cross-functional teams
- Outcome-oriented approach focused on delivering value to end users backed by measurable, data-driven results
- U.S. Citizenship; Ability to obtain Public Trust clearance
Benefits
- Eleven Federal Holidays
- Paid Time Off accrued each pay period
- Parental Leave
- Three medical plan choices with generous employer contribution
- Dental and Vision Insurance
- Company paid Short-Term and Long-Term Disability
- Company paid Life and AD&D Insurance
- 401k with competitive matching and vesting schedule
- Continuing education assistance
- Short Term / Long Term Disability & Life Insurance
- Medical, Dependent Care and Commuter Flexible Spending Accounts
- Employee Assistance Program
- Wellness benefits include Calm Health app and WellHub gym subsidy (formerly GymPass)
- 529 College Savings Plan
- Legal Insurance
- Pet Insurance
Related Guides
Related Categories
Related Job Pages
More Analytics Engineer Jobs
Analytics Engineer 5 – Content & Studio
NetflixPlay, pause, and resume watching anytime and anywhere.
• Design, build, and maintain scalable data models that serve as the source of truth for the Consumer Product team. • Partner with Business Stakeholders, Product Engineering, and Data Scientists/Data Engineers to understand data needs and translate complex business requirements into technical data solutions. • Transform complex quantitative analysis into high-impact dashboards and custom data tools (e.g., Plotly Dash) that drive business decisions. • Deliver scalable data solutions by merging advanced SQL and Python proficiency with data engineering workflows, ensuring reliability through engineering best practices like CI/CD, testing, version control and monitoring. • Proactively bring data-driven perspectives that challenge assumptions, uncover growth opportunities, and shape the future direction of Netflix Consumer Products. • Manage high-impact, long-term infrastructure projects while remaining agile enough to handle ad hoc data requests.
• Design, build, and maintain ETL/ELT pipelines using SQL/Apache Spark (AWS Glue) and Airflow. • Model and optimize data in Amazon Redshift and query large datasets via Amazon Athena. • Write advanced SQL to transform raw data into clean, joinable, analysis-ready tables. • Build and maintain Tableau dashboards and data sources, ensuring accuracy, performance, and usability for business stakeholders. • Partner with stakeholders (marketing, product, BI) to translate business questions into robust data models. • Ensure data quality by implementing checks/monitoring and documenting the data warehouse. • Improve pipeline reliability, performance, and cost-efficiency on AWS, including evaluating and adopting dbt for transformations.
Role Description As an Analytics Engineer 4 with Nextdoor, Inc. (San Francisco, CA) (May telecommute from any U.S. location) you’ll: - Apply mathematical or statistical theory and methods to design, create, and select the appropriate samples of data that will allow the data science team to conduct probabilistic experiments and statistical analyses. - Design software systems and processes to gather data in the most efficient way and determine key data points needed in order to interpret experiment results and ensure results are properly tracked. - Interpret data and report conclusions drawn from their analyses. - Work with cross-functional teams, including product, design, engineering, marketing, operations, and sales, to determine which data analyses will lead to the most actionable insights. - Build data pipelines to create and transform data for analysis of different product features. - Clean and summarize data to make it accessible for reporting and for data science. - Combine data from multiple sources to make and distribute client reports in order to see how particular ad products are performing. - Analyze expected vs actual delivery of ad products in order to find and improve gaps in our delivery pipeline. Qualifications - Master’s degree or foreign equivalent in Mathematics, Statistics, Business Analytics, or closely related quantitative field. - Three (3) years of experience in the role or in a related position. - Full term of experience must include the following: - Utilizing Data Analysis tools, such as Databricks or Snowflake, to support and improve business. - Utilizing Python and Structured Query Language (SQL) programming languages to conduct large scale data analyses. - Utilizing data processing languages, including Airflow or Alteryx, to build big data pipelines to extract and transform data. - Utilizing Tableau or Looker to generate reports and build dashboards and analyze data and create data insights. - Utilizing advanced MS Excel Functions, including VBA coding, Pivot Tables, and Power Point, to present project reports and recommendations to leadership teams. - Utilizing data analysis skills to collect large data sets to uncover and visualize hidden insights in core data. Benefits - The starting salary for this role is expected to be: $175,000 - $180,000/year. - We also expect to award a meaningful equity grant for this role. With equal quarterly vesting, your first vest date would be within the first 3 months of your start date. - Overall, total compensation will vary depending on your relevant skills, experience, and qualifications. - Nextdoor employees can choose between a variety of great health plans. We cover 100% of your personal monthly premium for health, dental, and vision – and provide a OneMedical membership for concierge care.
• As a Staff Analytics Engineer, you will own BeReal’s product analytics layer end-to-end. • Act as the most senior voice on analytics, reporting directly to the VP Engineering. • Partner closely with Product Managers, Engineers, and Data stakeholders to build a scalable, reliable, and self-service analytics foundation that empowers better product decisions. • Define and execute BeReal’s product analytics roadmap, aligning modeling, observability, and tooling with product priorities. • Partner closely with Product Managers to translate product loops, retention mechanics, and experimentation needs into scalable data models. • Build and deploy AI-powered internal analytics tools that enable stakeholders to query data in natural language. • Own the integration between BigQuery, Amplitude, and our experimentation framework to ensure a single source of truth for metrics. • Design and maintain a self-service metrics layer that enables PMs to independently analyze funnels and experiments. • Write production-grade dbt models and optimize SQL transformations for reliability, performance, and scalability. • Lead technical reviews and establish best practices for analytics engineering. • Collaborate with Backend and Mobile teams to ensure analytics instrumentation is robust and analytics-ready from day one. • Monitor data quality and observability to guarantee trust in product metrics and reporting.



