ETL Developer at Gunnison Consulting Group

Washington, District of Columbia, United States -

Full Time

Start Date

Immediate

Expiry Date

21 May, 26

Salary

107000.0

Posted On

20 Feb, 26

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

ETL, Data Integration, Data Warehousing, Stored Procedures, Data Mining, Machine Learning, Python, R, SAS, SQL, NoSQL, MapReduce, Tableau, AWS Glue, Azure Data Factory, Spark

Industry

Information Technology & Services

Description

Description * This position is contingent on a future opening with Gunnison. Salary: $100,000 - $107,000/year Key Responsibilities: ETL Process Design and Development: Design and implement ETL processes to extract data from various sources, transform it according to business requirements, and load it into target databases or data warehouses. Develop and maintain ETL scripts, stored procedures, and functions. Data Integration and Management: Generate new business insights through data extraction, storage, transformation, analysis, and visualization of diverse data sets. Analyzes data using data mining, machine learning, and statistical algorithms available in COTS tools (e.g. SAS, SPSS, and Oracle); builds analytical solutions using programming languages (e.g. R, Python, SAS), and programming libraries (e.g. Python SciKit, R Caret, PostgreSQL MADlib, Apache Spark MLlib). Ensure data integrity, consistency, and quality throughout the ETL process. Collects and transforms structured, unstructured, relational, and NoSQL data using ETL and ELT tools as well as develops custom code using programming languages. Understands and uses distributed (e.g. MapReduce) methods that scale to multi-Terabyte sized data collections. Interprets and evaluates accuracy of results through iterative, agile methods. Applies data discovery and data visualization tools (e.g. Tableau, Trifacta) to develop compelling, actionable, useful data stories. Works closely with data SMEs, business, and management to prioritize business and information needs. Requirements 8+ years of directly relevant experience. Experience working directly on a data science team. Experience working with tools, including object-oriented programming (Python, Java), computational analysis tools (R, MATLAB), and associated data science libraries (scikit-learn). Data science methods related to data architecture, data munging, data and feature engineering, and predictive analytics. Experience creating meaningful data visualizations and interactive dashboards using platforms such as Tableau, Qlik, Power BI, RShiny, plotly, and d3.js to communicate findings and relate them back to how your insights create business impact. Experience with cloud-based ETL solutions (e.g., AWS Glue, Azure Data Factory). Knowledge of Big Data technologies (e.g., Hadoop, Spark). Bachelors Degree in data science, mathematics, statistics, economics, computer science, engineering, or other related business or quantitative discipline is required. May substitute with commensurate experience (+4 years). Certification in relevant ETL or data integration technologies. Desired Qualifications: Bachelor’s degree in Computer Science, Information Technology, or a related field. Equivalent experience may be considered. Clearance Requirement: Ability to obtain and maintain a Public Trust. The salary range for this position depends upon multiple factors including location, the individual's knowledge, skills, competencies, and experience, and contract-specific budget constraints and organizational requirements. Gunnison Consulting Group's total compensation package also includes bonus and profit-sharing opportunities, depending on company and employee performance. Available employee benefits include: 3 weeks of Personal Leave your first year 11 paid Holidays each year 5 days of Flexible Time Off each year 401(k) company match at 50% up to 10% of your salary Medical, Dental and Vision Insurance Life and Disability Insurance Public Transportation Subsidies Certifications and Training Allowance - $2,500/year! Why Join Gunnison? Gunnison takes on ambitious projects. We target fun, challenging work that requires creative thinking and innovation. Quality is our top priority. Gunnison employee benefits meet or exceed what other companies in the Washington, D.C. metropolitan area offer. There is a great sense of camaraderie at Gunnison. This is an atmosphere we will maintain as we continue to grow. We are growing rapidly and the opportunity for individual professional growth with Gunnison is outstanding. We hire for careers at Gunnison, not to fill a position. Equal Opportunity Employer. Must be eligible for employment in the United States. We are unable to sponsor candidates at this time. In 1994 Gunnison began serving the greater Washington, D.C. metro area, focused on tackling our customers' most ambitious technology projects. By creating a culture dedicated to enabling our customers and employees to achieve more than they ever thought they could, the company has thrived for over 25 years.

Responsibilities

The role involves designing and implementing ETL processes to extract, transform, and load data from various sources into target databases or data warehouses, while also developing and maintaining associated scripts and stored procedures. Responsibilities include generating business insights through data analysis using machine learning and statistical algorithms, ensuring data integrity, and working closely with stakeholders to prioritize information needs.