243 Data Warehouse jobs in the United States

Job Description
Requirements

Top Required Skills & Years of Experience:

a. Gathering requirements and developing technical specifications for ETL - 6 years

b. Using ETL tools to design ETL jobs (ETL 6 years, MINIMUM 2 years of ETL with Alteryx)

c. Developing various types of data loads (e.g. incremental, history/full, survivorship rules) - 6 years

d. Implementing change data capture (CDC) - 4 years

e. Testing and debugging ETL - 6 years

f. Developing complex SQL - 6 years (should be recent experience)

g. ETL job scheduling - 2 years

h. Loading data warehouses using ETL tools - 2 years

Nice to Have Skills:

a. Management of multiple ETL tools

b. Experience with data quality tools and frameworks - preferred

c. Using source code version control software - preferred

BACKGROUND

Tulsa For You and Me: a collection of talent and economic development programs building a vibrant and inclusive city through a booming economic landscape for Tulsa. We are forging strategic connections between talented professionals and innovative companies in future-focused industries. Operated under the stewardship of the George Kaiser Family Foundation® (GKFF®), affiliated programs include nationally recognized and innovative organizations like Tulsa Remote, LLC, Tulsa Innovation Labs, LLC, inTulsa Initiative, LLC, Build In Tulsa, LLC, Atlas School, LLC, Campus Tulsa program, and Tulsa Service Year program, among others.

Our North Star goal is both ambitious and clear: to attract and build 20,000 jobs in high-growth industry clusters by the year 2033. A cornerstone of this mission is our commitment to ensuring that at least one-third of these opportunities are accessible to Tulsans from historically underrepresented communities. This is an extension of our broader vision for a more equitable, innovative, and vibrant Tulsa, where a strong state of economic health provides the basis for equal opportunity.

The Integrated Strategies group is composed of several expert teams dedicated to fostering cross-program collaboration, driving operational excellence, and equipping Tulsa for You programs with the tools, insights, and best practices to drive tangible results. The Integrated Strategies group includes teams focused on Technology, Research & Analytics, Marketing, and Operations. Join our high-impact team, where your work will have a lasting impact on the Tulsa community and its future.

PRIMARY PURPOSE AND FUNCTIONS

In this position, you will play a crucial role in managing and optimizing our data processes within our emerging Data Warehouse/Data Lake environments. This position requires a strong foundation in Python programming, ETL systems, and tools and a solid understanding of relational databases. You will work to ensure the efficiency and reliability of our data pipelines, contributing directly to the success of our projects. You will maintain all the back-end hardware and platforms to enable these applications and systems to run harmoniously with the Research and Data Analytics department. Azure experience is a strong plus.

Requirements

ESSENTIAL FUNCTIONS AND RESPONSIBILITIES

• Monitor performance and troubleshoot issues within ETL projects, proposing and implementing effective solutions to optimize system performance.
• Collaborate with data engineers, analysts, and other stakeholders to integrate new data sources and ensure seamless data flow and accessibility across the organization.
• Assist in the development and testing of new features, models, or data processes within our data warehouses, leveraging feedback to drive continuous improvement.
• Document data processes, models, and workflows within our data warehouses for internal knowledge sharing and to support ongoing learning and development.
• Stay updated on the latest data warehouse management features and best practices, applying this knowledge to innovate and improve project outcomes.
• Implement and maintain security protocols and data governance practices to ensure compliance with organizational policies and industry regulations.
• Evaluate and recommend new tools, technologies, and methodologies to enhance data processing and storage capabilities.
• Collaborate with data engineers, analysts, and other stakeholders with data flows, scripts, and models within Dataiku and other ETL systems, optimizing for performance and reliability.
• Collaborate with data engineers, analysts, and other stakeholders to ensure integrity and quality of data throughout the entire data lifecycle, from ingestion to analysis, by implementing data validation and cleansing processes.
• Other duties as assigned.

KNOWLEDGE EXPERIENCE AND SKILL REQUIREMENTS

Education & Experience:

• 4+ years experience managing data warehouses and ETL systems.

Preferred:

• 4-5 years working with Azure Data Warehouses.
• 2-3 years experience with version control systems, such as Git.
• 2-3 years experience in other data science and machine learning tools and frameworks (e.g., scikit-learn, TensorFlow, PyTorch, Java, Apex).

Skills & Abilities:

• Strong abilities in creating and optimizing data warehouses in Azure, but knowledgeable in AWS and GCP.
• Conceptual understanding of relational databases and data querying.
• Strong proficiency in writing and modifying database centric API's.
• Familiarity with Dataiku and other ETL systems or a willingness to learn and master the platform.
• Excellent problem-solving skills and attention to detail.
• Strong proficiency in cloud computing platforms.
• Proficiency in containerization and virtualization technologies.
• Ability to work independently and collaboratively in a team environment.
• Strong communication skills, with the ability to document and explain technical details clearly.

Physical Requirements:

• Position continually requires the ability to talk and hear both in person and over the phone, visual acuity; ability to operate equipment, read, and use a keyboard.
• Position frequently requires the ability to sit, walk, and stand for extended periods of time.
• Position requires limited travel, predominantly for professional development and/or learning opportunities.

Hours & Location:

• You must live in or be able to relocate to Tulsa, OK or the surrounding area.
• This is not a fully remote position as we work in a hybrid office environment. In-Office and hybrid/flexible schedules are based on business need, staff readiness, and approved by one's supervisor.
• This is a full-time position with an expectation of working 40 hours per week.
• The typical hours of operation are Monday through Friday, 8:00 a.m. to 5:00 p.m.
• The typical hours of operation are Monday through Friday, 8:00 a.m. to 5:00 p.m. with flexibility required for various events, meetings, and relevant business needs.

Benefits and Compensation:

As part of our overall compensation package, we offer work/life flexibility, comprehensive health benefits, paid time off, and generous retirement contributions designed to support you and your family.

Details:

• 100% employer paid medical, dental, and long-term disability for full-time employees only. Option to add vision and dependents.
• 401K employee and employer contributions.
• Paid time off to support you while you are out of the office.
• Paid holidays so our employees can spend time with those they care about.
• Employer paid AD&D life insurance, with employee option to add supplemental life insurance.

Salary Description

$103,000 - $120,000/year

Title- DATA WAREHOUSE ANALYST

Location: Onsite in Houston (hybrid- 3 days/week)
Contract Duration: 6 months

Required Skills/Initial Tasks:
Must Have:
IT experience including
- 12+ years of experience in application development
- 7+ years of experience in Oracle 11g or higher
- 7+ years of experience in Oracle PL/SQL development
- 5+ years of experience in Unix/Linux shell script development
- 5+ years of experience in a Data Warehouse environment
- 2+ years of experience in a Collibra

NICE TO HAVE:
Additional skills:

• Python experience is not required but recommended
• Informatica Power Center experience
• Experience in a de-regulated utilities business (in Texas is a plus)
• Oracle SQL developer or PL/SQL Developer
• Power BI
• SAP knowledge/experience
• Excellent verbal and written communication skills are required in order interact with the business team, SME, production support lead, and other team members.
• Flexibility, dedication, and team-spirit is a must

NRG * SIZZLE *:

• Innovative Culture: NRG fosters an environment that encourages creativity and innovation, driving the development of cutting-edge energy solutions.
• Sustainability Focus: Join a company committed to sustainability and renewable energy, making a tangible impact on the environment and future generations.
• Collaborative Environment: Be part of a team that values collaboration, diversity, and inclusion, creating a supportive workplace for everyone.

Data Warehouse Engineer

LOCATION
Annapolis Junction, MD 20701
CLEARANCE
TS/SCI Full Poly (Please note this position requires full U.S. Citizenship)
KEY SUMMARY
We are looking for a detail-oriented and innovative Data Warehouse Engineer to join our team and help design, build, and maintain high-performance data warehousing solutions. In this role, you will collaborate with cross-functional teams to structure and optimize large-scale data environments, ensuring efficient data integration, storage, and accessibility for analytics and reporting. You will be responsible for implementing ETL processes, maintaining data quality, and ensuring the scalability of our data warehouse systems. The ideal candidate has a strong foundation in data modeling, data architecture, and best practices for managing large datasets, with a passion for driving data-driven decision-making. If you are excited about working with complex data systems and creating robust data infrastructure, we want to hear from you.
*** Please note that our job openings are dynamic and can open or close quickly (much faster than we can publish). If you do not see an opening you are looking for, know that we see almost all types of positons. We strive to keep our listings up to date, but please consider submitting your current resume. Our team will work with you to identify the most recent opportunities that align with your skillset and career goals. We look forward to you joining our family. ***

SIMILAR CAREER TITLES
Data Engineer, ETL Developer, Data Architect, Business Intelligence Engineer, Data Integration Engineer, Database Engineer, Data Systems Engineer, Analytics Engineer, Big Data Engineer, Data Infrastructure Engineer, ect.
DEGREE (Level Desired)
Bachelor's Degree
DEGREE (Focus)
Computer Science, Information Systems, Data Science, Software Engineering, Mathematics, Statistics, Database Management, Information Technology, Business Analytics, Applied Science, ect.
ALTERNATE EXPERIENCE
General comment on degrees: Most contracts allow additional experience (4-5 years) in lieu of a Bachelor's Degree. Some contracts give 4-5 years experience credit for a Bachelor's Degree. Some contracts give 2 years experience credit for a Master's Degree. We will work with you to find the right fit.
POSITION RESPONSIBILITIES

• Experience with data warehouse architecture
• Proficiency in ETL tools and processes
• Ability to design and implement data models
• Expertise in data integration and transformation
• Strong knowledge of database management systems
• Understanding of data governance and compliance

REQUIRED SKILLS

• Proficiency in SQL and relational databases
• Familiarity with cloud-based data warehouses
• Expertise in data quality management
• Experience with data pipeline orchestration
• Strong understanding of data warehousing concepts
• Skill in performance tuning of data systems

DESIRED SKILLS

• Knowledge of NoSQL databases
• Experience with real-time data processing
• Familiarity with business intelligence tools
• Understanding of data security protocols
• Experience in handling unstructured data
• Familiarity with machine learning integration

PLUG IN to CYMERTEK - And design your future.

YOUR FOREVER CAREER STARTS HERE

Are you looking for more than just a job? Join a company where employees are treated like family, and your career is built to last. We are a growing small business and a trusted federal contractor offering full scope consulting services in information technology, cybersecurity, and analyst workforce development.

At our company, you come first. We're committed to creating an environment where you'll thrive professionally and personally. We provide meaningful, challenging work using cutting-edge technologies while investing in your growth and success. With direct access to company leadership, a laid-back and inclusive atmosphere, and exceptional work-life balance, you'll feel valued every day.

We also believe in taking care of our family - both yours and ours. Our benefits are phenomenal, family-friendly, and designed with your well-being in mind. From employee and family events to career-long support, we create a community you'll never want to leave.

Ready to make your next move the best one? Join us and experience the difference.

BENEFITS

• Excellent Salaries
• Flexible Work Schedule
• Cafeteria Style Benefits
• 10% - 401k Matching (Vested Immediately)
• Additional 401k Profit Sharing
• 30 days Paid Leave/Holiday (No Use or Lose!)
• The day off for your birthday
• Medical/Dental/Vision - 100% employee coverage. ($1200 allowance - or a bonus)
• HSA/FSA
• AFLAC
• Long Term/Short Term Disability - 100% employee coverage. No cost to you.
• Life Insurance - 100% employee coverage. No cost to you.
• Additional Discretionary Life Insurance
• Paid Training
• No long, wordy reviews with tons of paperwork!
• Referral bonus program with recurring annual payments

HOW TO APPLY

Email us at or apply today:

Want to see what our employees think? Click here .

EQUAL OPPORTUNITY EMPLOYER STATEMENT

Cymertek is proud to be an Equal Opportunity Employer committed to fostering an inclusive and diverse workplace. We embrace and celebrate differences in our employees, recognizing that a diverse workforce enhances our creativity, innovation, and overall success. At Cymertek, employment decisions are made based on merit, qualifications, and business needs without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other characteristic protected by applicable laws. We believe in creating an environment where all individuals are treated with respect and dignity, and where opportunities for professional growth and advancement are accessible to everyone, regardless of background or identity.

Data Warehouse Engineer

LOCATION
Aurora, CO 80014
CLEARANCE
TS/SCI Full Poly (Please note this position requires full U.S. Citizenship)
KEY SUMMARY
We are looking for a detail-oriented and innovative Data Warehouse Engineer to join our team and help design, build, and maintain high-performance data warehousing solutions. In this role, you will collaborate with cross-functional teams to structure and optimize large-scale data environments, ensuring efficient data integration, storage, and accessibility for analytics and reporting. You will be responsible for implementing ETL processes, maintaining data quality, and ensuring the scalability of our data warehouse systems. The ideal candidate has a strong foundation in data modeling, data architecture, and best practices for managing large datasets, with a passion for driving data-driven decision-making. If you are excited about working with complex data systems and creating robust data infrastructure, we want to hear from you.
*** Please note that our job openings are dynamic and can open or close quickly (much faster than we can publish). If you do not see an opening you are looking for, know that we see almost all types of positons. We strive to keep our listings up to date, but please consider submitting your current resume. Our team will work with you to identify the most recent opportunities that align with your skillset and career goals. We look forward to you joining our family. ***

SIMILAR CAREER TITLES
Data Engineer, ETL Developer, Data Architect, Business Intelligence Engineer, Data Integration Engineer, Database Engineer, Data Systems Engineer, Analytics Engineer, Big Data Engineer, Data Infrastructure Engineer, ect.
DEGREE (Level Desired)
Bachelor's Degree
DEGREE (Focus)
Computer Science, Information Systems, Data Science, Software Engineering, Mathematics, Statistics, Database Management, Information Technology, Business Analytics, Applied Science, ect.
ALTERNATE EXPERIENCE
General comment on degrees: Most contracts allow additional experience (4-5 years) in lieu of a Bachelor's Degree. Some contracts give 4-5 years experience credit for a Bachelor's Degree. Some contracts give 2 years experience credit for a Master's Degree. We will work with you to find the right fit.
POSITION RESPONSIBILITIES

• Experience with data warehouse architecture
• Proficiency in ETL tools and processes
• Ability to design and implement data models
• Expertise in data integration and transformation
• Strong knowledge of database management systems
• Understanding of data governance and compliance

REQUIRED SKILLS

• Proficiency in SQL and relational databases
• Familiarity with cloud-based data warehouses
• Expertise in data quality management
• Experience with data pipeline orchestration
• Strong understanding of data warehousing concepts
• Skill in performance tuning of data systems

DESIRED SKILLS

• Knowledge of NoSQL databases
• Experience with real-time data processing
• Familiarity with business intelligence tools
• Understanding of data security protocols
• Experience in handling unstructured data
• Familiarity with machine learning integration

PLUG IN to CYMERTEK - And design your future.

YOUR FOREVER CAREER STARTS HERE

Are you looking for more than just a job? Join a company where employees are treated like family, and your career is built to last. We are a growing small business and a trusted federal contractor offering full scope consulting services in information technology, cybersecurity, and analyst workforce development.

At our company, you come first. We're committed to creating an environment where you'll thrive professionally and personally. We provide meaningful, challenging work using cutting-edge technologies while investing in your growth and success. With direct access to company leadership, a laid-back and inclusive atmosphere, and exceptional work-life balance, you'll feel valued every day.

We also believe in taking care of our family - both yours and ours. Our benefits are phenomenal, family-friendly, and designed with your well-being in mind. From employee and family events to career-long support, we create a community you'll never want to leave.

Ready to make your next move the best one? Join us and experience the difference.

BENEFITS

• Excellent Salaries
• Flexible Work Schedule
• Cafeteria Style Benefits
• 10% - 401k Matching (Vested Immediately)
• Additional 401k Profit Sharing
• 30 days Paid Leave/Holiday (No Use or Lose!)
• The day off for your birthday
• Medical/Dental/Vision - 100% employee coverage. ($1200 allowance - or a bonus)
• HSA/FSA
• AFLAC
• Long Term/Short Term Disability - 100% employee coverage. No cost to you.
• Life Insurance - 100% employee coverage. No cost to you.
• Additional Discretionary Life Insurance
• Paid Training
• No long, wordy reviews with tons of paperwork!
• Referral bonus program with recurring annual payments

HOW TO APPLY

Email us at or apply today:

Want to see what our employees think? Click here .

EQUAL OPPORTUNITY EMPLOYER STATEMENT

Cymertek is proud to be an Equal Opportunity Employer committed to fostering an inclusive and diverse workplace. We embrace and celebrate differences in our employees, recognizing that a diverse workforce enhances our creativity, innovation, and overall success. At Cymertek, employment decisions are made based on merit, qualifications, and business needs without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other characteristic protected by applicable laws. We believe in creating an environment where all individuals are treated with respect and dignity, and where opportunities for professional growth and advancement are accessible to everyone, regardless of background or identity.

MAIN FUNCTION:

We are seeking a highly skilled and experienced Data Warehouse Analyst to oversee the management and optimization of our data warehouse systems. The successful candidate will lead cross-functional teams, drive data strategies in alignment with business objectives, and ensure seamless integration across various departments.

QUALIFICATIONS:

• Experience : Minimum of 5 years of experience in data warehousing, business intelligence, or a similar role. Proven experience in data warehousing or a similar role, with a track record of successful data warehouse implementations and ongoing maintenance.
• Technical Proficiency : Strong understanding of data warehouse technologies, database management systems, and programming languages such as SQL, with expertise in maintaining system performance and updates.
  • Strong foundation in Microsoft SQL Server
  • Experience with cloud platforms like Azure Synapse, Amazon Redshift a plus
  • Familiarity with Data Lake/Lakehouse models
  • Proficiency with ETL tools such as Azure Data Factory, SSIS
  • Power BI expertise including DAX and service admin
• Analytical Skills : Ability to analyze complex business processes and data sets to optimize data warehouse performance and ensure continuous improvement. Analyze both structured and unstructured data to provide comprehensive insights.
• Project Management Skills : Excellent organizational and leadership abilities, with proficiency in project management methodologies and tools for both implementation and maintenance phases.
• Communication Skills : Strong verbal and written communication skills, capable of conveying complex data warehouse concepts to non-technical stakeholders, facilitating ongoing support and training.
• Problem-Solving Aptitude : Demonstrated ability to troubleshoot issues and implement effective solutions during data warehouse deployment and post-implementation maintenance.
• Adaptability : Willingness to stay updated with the latest advancements in data warehouse technologies and integrate them into business processes, ensuring the system remains current and efficient.
• Educational Background : Bachelor's or Master's degree in Computer Science, Information Technology, Business Administration, or a related field, with a focus on systems management and maintenance.
  • Relevant certifications (e.g., PMP, data warehousing certifications, BI certifications) are a plus.
• Experience in Business Intelligence (BI) and Data Warehousing (DW) : Essential for transforming raw data into meaningful information that supports decision-making and enhances business operations and outcomes.
• Modern Data Architecture & Storage: Cloud Data Warehousing
  • Experience with platforms like Azure Synapse Analytics, Amazon Redshift, or Google BigQuery

WORKING CONDITIONS:

The work environment characteristics are representative of those an employee encounters while performing the essential functions of this job.

KEY RELATIONSHIPS:

• Executive Management : Collaborate with senior leaders to align data warehouse strategies with organizational goals and secure necessary resources.
• Department Heads : Work closely with heads of various departments to identify data integration opportunities and ensure smooth implementation.
• IT and Development Teams : Coordinate with technical teams to oversee the configuration, customization, and deployment of data warehouse modules. Ensure data warehouse systems comply with data privacy regulations and maintain robust security standards.
• End Users : Provide training and support to employees to facilitate effective utilization of data warehouse systems.

DUTIES AND RESPONSIBILITIES:

To perform this job successfully, the individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Data Warehouse Strategy : Develop and implement data warehouse strategies that align with the organization's business objectives.

• Project Management : Lead data warehouse projects from conception through deployment, ensuring timely and within-budget delivery.
• Cross-Functional Collaboration : Work closely with various departments to identify opportunities for data integration and ensure seamless implementation.
• Technical Oversight : Supervise the development and optimization of data warehouse systems, ensuring they meet business requirements and performance standards.
• Training and Support : Conduct training sessions for employees on data warehouse systems and provide ongoing support to ensure effective utilization.
• Performance Monitoring : Continuously monitor data warehouse system performance, making necessary adjustments to improve efficiency and effectiveness.
• Compliance Assurance : Ensure all data warehouse implementations comply with data privacy regulations and industry standards.
• Vendor Management : Manage relationships with data warehouse technology vendors and service providers to facilitate successful implementations.

COMPENSATION:

The base salary range for this position is $100,000 to $115,000; the exact salary depends on several factors such as experience, skills, education, and budget.

BENEFITS OVERVIEW:

We offer a competitive benefits package that includes medical, dental, vision, basic life and AD&D coverage, short- and long-term disability, a 401(k) retirement plan, annual discretionary salary increases and bonuses. Employees receive paid company holidays, paid time off, and access to company-paid training. Optional benefits include tuition reimbursement, a 529 college savings plan, pet insurance, legal and ID theft coverage, and other voluntary insurance plans.

Job Description

Lead the design development and maintenance of enterprise data warehouse and data analytics environment. Possess expertise in modern data architecture, data warehousing, data integration, cloud computing, and analytics solutions. Work with cross-functional teams to define, develop, and optimize enterprise data architecture supporting business intelligence (BI) and advanced analytics initiatives. Job duties:

• Lead the selection and implementation of appropriate data warehousing technologies, including database platforms, ETL/ELT tools, and BI platforms.
• Work with business stakeholders, data analysts, data scientists, and BI developers to understand business needs and create data warehouse specifications.
• Develop and maintain conceptual, logical, and physical data models, ensuring alignment with business requirements and best practices.
• Design and architect the data warehouse and BI architecture, including integration, storage, processing, and presentation, either independently or in collaboration with external consultants.
• Work closely with Enterprise IT teams, including SAP infrastructure and database administrators, as well as enterprise system developers and administrators.
• Develop, implement, and maintain end-to-end data pipelines, designing efficient ETL/ELT processes to extract, transform, and load data from diverse sources (e.g., SAP, Hyperion, PLM/QMS systems, flat files, APIs) into the data warehouse.
• Develop and oversee a future roadmap for optimizing cloud data architecture, ensuring scalability, performance, and cost efficiency.
• Design and implement real-time and batch data processing solutions using modern data processing frameworks and tools.
• Ensure data security, compliance, governance, quality, and effective metadata management.
• Manage the software development lifecycle related to the data warehouse and create standard operating procedures.
• Comply with applicable Laws and Regulations, adhere to Quality Management System processes and requirements as well as demonstrate Ethics and Integrity in all matters and at all levels throughout the organization.
• Perform additional duties as assigned.

Qualifications

1. Bachelor's degree in computer science, Information Systems, or a related field, or equivalent combination of education and experience.
2. Minimum five (5) years of experience in data warehousing, data architecture, and business intelligence solutions.
3. Deep understanding of data warehousing concepts, including dimensional modeling, star schema, and snowflake schema for large-scale date modeling.
4. Proven knowledge of SQL Server for database management, data modeling, and query optimization.
5. Expertise in data integration and transformation tools and methodologies (e.g., SSIS, Azure Data Factory, SAP Data Services, etc.).
6. Expertise in data visualization and business intelligence tools, particularly Power BI, or other BI platforms.
7. Strong knowledge of data governance, security, and compliance standards.
8. Excellent written and verbal communication, collaboration, and critical thinking skills.
9. Proficient with MS Word, Excel, Outlook, and Teams.

Desired Qualifications

1. Experience with ERP systems (e.g., SAP S/4HANA, Oracle, etc.) for data extraction and transformation.
2. Proficient in Azure Cloud, big data technologies (e.g., Spark, Data Lake), and Business Analytics.
3. Experience with project management involving a data lake implementation.
4. Ability to create reports, dashboards, and visualizations to support business decision-making.
5. Experience as a lead and/or senior member of a data warehouse team.
6. General knowledge of GxP, SOX, and other auditable data management requirements.
7. Knowledge of data science and machine learning concepts.
8. Experience with DevOps practices and tools.
9. Certification(s) in Data Architecture, Big Data, Data Engineering, Integrations, and other relevant technologies.

About the job Data Warehouse Developer

Data Warehouse Developer needs 7 years experience in data warehousing development, implementation, and support.

Data Warehouse Developer requires:

• Strong SQL analysis skills and experience in database tuning and optimization. Experience in data modeling using Kimball methodology is preferred.
• At least 3 years of experience in Oracle Data Integrator (ODI) 12c version.
• Excellent team player with strong communication skills. Ability to work in a fast-paced environment with minimal supervision.
• Hybrid role with 2 days in office.

Data Warehouse Developer duties:

• Design, develop, and maintain the data warehouse using Oracle database and Oracle Data Integrator (ODI) for ETL.
• Work with stakeholders to gather and analyze requirements for data warehousing solutions.
• Develop ETL jobs using ODI to extract, transform, and load data from various sources into the data warehouse.
• Perform performance tuning of the data warehouse, ETL jobs, and SQL queries to ensure optimal performance and scalability.
• Develop and maintain data models using Kimball methodology for data warehousing design. Support data operations by monitoring, troubleshooting, and resolving data issues.
• Collaborate with the development team to integrate data warehouse solutions with other enterprise systems.

Description

Under the direction of the Enterprise Application Manager, the Data Warehouse Developer is a detail-oriented and technically skilled individual who will lead the design, development, and maintenance of enterprise data integration and reporting solutions. This hybrid role emphasizes SQL-based Extract, Transform, Load (ETL) development and data modeling to support the agency's centralized data warehouse and cross-departmental reporting needs. The position is responsible for building robust, scalable ETL pipelines to unify data from disparate operational systems, ensuring consistent, high-quality data is available for analytics and decision-making. Additionally, the role includes supporting enterprise applications (ERP, asset management, etc.) with a focus on data integrity, reporting integration, and process optimization.

ESSENTIAL FUNCTIONS

The following duties are standard for this position. The omission of specific statements of duties does not exclude them from the classification if the work is similar, related, or a logical assignment for this classification.

• Design, develop, and manage end-to-end SQL-based ETL processes to ingest and transform data from ERP, CAD/AVL, APC, fare systems, and other operational sources.

• Build and optimize data models, views, stored procedures, and scripts in Microsoft SQL Server or similar platforms to support a scalable enterprise data warehouse.

• Implement and monitor automated ETL workflows, ensuring reliability, accuracy, and performance of scheduled data pipelines.

• Collaborate with business units to define data requirements and translate them into reliable, well-structured datasets for self-service reporting and analysis.

• Develop and maintain reporting and dashboard solutions using tools such as Power BI, SSRS, or Tableau.

• Participate in data governance efforts by documenting transformation logic, managing metadata, and ensuring data consistency and security across systems.

• Provide Tier 1 and Tier 2 technical support for core enterprise systems, focusing on data integrity, reporting alignment, and API/data integration troubleshooting.

• Assist in application upgrades and configurations with a focus on how changes impact data flows and reporting.

• Work closely with the Enterprise Application Manager to align data infrastructure with long-term business intelligence strategies.

Requirements

QUALIFICATION GUIDELINES

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Where applicable, an equivalent combination of education and experience may be considered in lieu of education/experience listed below.

Education/Experience

• Bachelor's degree in Information Systems, Computer Science, Data Analytics, or a related field.

• Minimum of 5 years of hands-on experience with SQL development and ETL pipeline creation in a business intelligence or data engineering role.

• Strong proficiency in T-SQL and experience working with large, complex datasets in a relational database environment.

• Experience with ETL tools and frameworks (e.g., SSIS, Azure Data Factory, custom scripting).

• Familiarity with reporting/visualization tools such as Power BI, SSRS, or Tableau.

• Ability to troubleshoot data issues and communicate technical details clearly to non-technical stakeholders.

• Strong analytical skills and attention to data quality, performance, and maintainability.
Preferred Qualifications

• Experience with Microsoft SQL Server, including performance tuning and job automation.

• Familiarity with Azure data tools, including Data Factory, Synapse, or Blob Storage.

• Knowledge of ERP platforms such as Tyler Munis or similar public sector systems.

• Understanding of public transit data structures (e.g., GTFS, NTD) and experience integrating data from operational and planning systems.

• Exposure to data governance frameworks, ITIL principles, or cybersecurity practices.

PHYSICAL ACTIVITIES : Physical activity includes, but is not limited to: on a continuous basis, sit at a desk for long periods of time; intermittently twist and reach office equipment; write or use keyboard to communicate through written means; lift moderate weight; reaching above the waist, reaching below the waist, and reaching waist to shoulder to reach inventory on shelves; repetitive motion and fingering when using a computer keyboard; talking and hearing when dealing with customers; and observation of transit projects and operations during field work along the right-of-way.