

Senior Data Integration / Business Intelligence Developer || Only W2 Role || Only Local
β - Featured Role | Apply direct with Data Freelance Hub
This role is a Senior Data Integration / Business Intelligence Developer in Saint Louis, MO, for a long-term contract. Requires 7+ years in SQL, UNIX scripting, and ETL, plus experience with Amazon Redshift and other data platforms.
π - Country
United States
π± - Currency
$ USD
-
π° - Day rate
-
ποΈ - Date discovered
June 26, 2025
π - Project duration
Unknown
-
ποΈ - Location type
On-site
-
π - Contract type
W2 Contractor
-
π - Security clearance
Unknown
-
π - Location detailed
St Louis, MO
-
π§ - Skills detailed
#Cloud #Data Warehouse #EDW (Enterprise Data Warehouse) #Data Integration #Scala #Scripting #SQL (Structured Query Language) #Deployment #Amazon Redshift #Snowflake #Unix #Oracle #Talend #Airflow #Visualization #AWS (Amazon Web Services) #BI (Business Intelligence) #Documentation #Informatica #Teradata #SQL Server #Apache Airflow #Data Governance #Redshift #Data Quality #Azure #Computer Science #Project Management #Business Analysis #"ETL (Extract #Transform #Load)"
Role description
Heading 1
Heading 2
Heading 3
Heading 4
Heading 5
Heading 6
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Block quote
Ordered list
- Item 1
- Item 2
- Item 3
Unordered list
- Item A
- Item B
- Item C
Bold text
Emphasis
Superscript
Subscript
Job Title: Senior Data Integration / Business Intelligence (BI) Developer
Location: Saint Louis, MO (Onsite)
Job Type: Long-Term Contract
Job Summary
We are seeking an experienced Senior Data Integration / BI Developer to join our team in Saint Louis, MO. This position plays a key role in designing, developing, and maintaining robust data integration and business intelligence solutions. You will work closely with IT, architecture teams, business analysts, and report developers to translate business needs into scalable data solutions.
Key Responsibilities
β’ Collaborate with business stakeholders and BI teams to gather and analyze data requirements.
β’ Design and implement scalable data integration solutions using ETL/ELT methodologies and UNIX scripting.
β’ Write complex SQL scripts to extract, transform, and load data in enterprise data warehouses.
β’ Work extensively with Amazon Redshift and at least one of: Teradata, Snowflake, Oracle, or SQL Server.
β’ Design and optimize fact and dimension data models to support reporting and analytics.
β’ Develop ad-hoc reports and dashboards to support data-driven decision-making.
β’ Identify, troubleshoot, and resolve data quality and performance issues.
β’ Collaborate with technical architects to enforce best practices in data integration and modeling.
β’ Create and maintain technical documentation for deployment and ongoing maintenance.
β’ Lead project deliverables, coordinate meetings, and ensure alignment between business and technical stakeholders.
Required Qualifications
β’ Bachelor's degree in Computer Science, Information Technology, Electrical Engineering, or related field.
β’ 7+ years of experience writing complex SQL in enterprise data warehouse environments, including at least two of the following:
β’ Teradata
β’ Snowflake
β’ Oracle
β’ SQL Server
β’ Amazon Redshift
β’ 7+ years of experience in data integration using UNIX scripting and ETL methodologies.
β’ 7+ years of experience designing fact and dimension models and implementing data visualization solutions.
β’ 7+ years of experience delivering enterprise-level IT and BI solutions.
β’ 5+ years of experience in project management, stakeholder engagement, and cross-functional collaboration.
Preferred Skills (Nice to Have)
β’ Experience with cloud data platforms (AWS, Azure).
β’ Familiarity with data governance and data quality frameworks.
β’ Knowledge of tools such as Informatica, Talend, or Apache Airflow.