Job Closed
This listing is no longer active.
A Global, Salesforce Marketing Cloud Implementation Partner.
Database, Data Warehouse Developer
Location
United States
Posted
95 days ago
Salary
$110K - $140K / year
Seniority
Senior
Job Description
Database, Data Warehouse Developer
Decision Foundry
• Develop, and maintain database solutions and data warehouse architectures using MSSQL 2019/2022 and MySQL 8. • Collaborate with stakeholders to gather requirements and understand business needs for data storage and processing. • Develop and maintain ETL processes using SSIS, BIML, and DBT to ensure efficient data integration and transformation. • Implement and manage solutions within Power BI Fabric for enterprise-scale data analytics. • Write complex SQL queries, stored procedures, functions, and triggers to support application and reporting requirements. • Optimize query performance through indexing strategies, execution plan analysis, and database tuning techniques. • Troubleshoot and resolve database performance issues, data integrity problems, and system bottlenecks. • Monitor database health, perform capacity planning, and implement proactive maintenance strategies. • Develop automation scripts using PowerShell and Python to streamline database operations and maintenance tasks. • Ensure data security, backup and recovery procedures, and compliance with organizational standards. • Utilize version control tools such as Git and project management tools like Jira and Confluence or similar platforms as required. • Work effectively in a team environment, collaborating on concurrent developments and contributing to team success. • Document database architectures, ETL processes, standards, and procedures. • Stay current with database technologies, best practices, and emerging trends in data warehousing. • Provide technical guidance and support to team members and end-users as needed. • Contribute to continuous improvement initiatives related to data management and analytics infrastructure.
Job Requirements
- 3+ years of experience in database development and data warehouse solutions.
- Bachelor's degree in Computer Science, Information Systems, or related field.
- Proven experience as a Database Developer, Data Warehouse Developer, or similar role.
- Strong proficiency in MSSQL 2019/2022 and MySQL 8, including advanced SQL programming.
- Hands-on experience with ETL tools and frameworks: SSIS, BIML, and DBT.
- Experience with Power BI Fabric and its integration with data warehouse solutions.
- Expert-level SQL skills with demonstrated ability in query optimization, performance tuning, and troubleshooting.
- Deep understanding of database design principles, normalization, dimensional modeling, and indexing strategies.
- Proficiency in scripting and automation using PowerShell and Python.
- Experience with version control systems (Git) and collaboration tools (Jira, Confluence, or similar).
- Excellent analytical and problem-solving skills with attention to detail.
- Strong communication and collaboration skills, with the ability to work effectively with stakeholders at all levels.
- Ability to work independently and manage multiple priorities in a fast-paced environment.
- Certification in Microsoft SQL Server, MySQL, or related database technologies is preferred.
- Knowledge of cloud data platforms (Azure, AWS, or GCP) is a plus.
Benefits
- Work Model – Remote
- Employment Type - Full-time
- Salary - $110K - $140K USD
- Decision Foundry is an equal opportunity employer and values diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment.
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
SQL Data Migration Specialist
2COMS Consulting Pvt. Ltd.Recruitment I General Staffing I IT Staffing I GigForce I Apprenticeship Implementation I Hire Train Deploy
• Lead data analysis, mapping, and transformation efforts • Collaborate with project teams to define requirements • Perform comprehensive data analysis and cleansing • Develop, test, and implement SQL-based ETL scripts • Validate migration outcomes through rigorous testing
• Build and maintain production-ready data pipelines using DBT, Snowflake, and modern orchestration tools. • Own data engineering features end-to-end, from implementation through optimization and deployment. • Fix and improve existing pipelines - identify bottlenecks, resolve issues, and enhance performance. • Drive automation initiatives across the data stack to accelerate delivery and reduce manual interventions. • Provide 2nd line support for B2B customers - investigate data issues, clarify edge cases, and ensure customers can trust their data. • Design and implement new data import pipelines as we expand our data source coverage. • Implement data quality improvements - validation, monitoring, and testing to ensure reliable, accurate data delivery. • Contribute to code reviews, architectural discussions, and data engineering best practices.
• Collaborate with team members and stakeholders to understand data requirements and contribute to building scalable data pipelines and workflows in Databricks. • Develop and implement ETL/ELT processes using Databricks, Python, SQL, and related tools to ingest, transform, and prepare data. • Assist in optimizing data workflows for better performance, reliability, and cost-efficiency within Databricks environments. • Support the creation and maintenance of data models, tables, and integrations in cloud platforms (Azure, AWS, or similar). • Work closely with cross-functional teams (data analysts, scientists, and engineers) to deliver clean, accessible data for analytics and reporting. • Monitor data pipelines, troubleshoot basic issues, and contribute to documentation and best practices. • Stay curious about new Databricks features and data engineering trends to support ongoing improvements.
• Kierowanie budową i rozwojem nowych potoków danych w środowisku RTB. • Projektowanie systemów o ultra-niskiej latencji (miliony QPS), w tym budżetowanie latencji oraz optymalizacja wydajności. • Leadership technologiczny: podejmowanie decyzji architektonicznych, mentoring zespołu, wypracowywanie kompromisów technicznych pomiędzy jakością, skalowalnością i time-to-market. • Udział w implementacji rozwiązań w Pythonie, SQL i Kafka; analiza kodu w Go w serwisach partnerskich; praca ze stosem Scala/JVM (Spark/Flink). • Zarządzanie procesem wdrożeń oraz utrzymaniem systemów w środowisku chmurowym (głównie GCP).
