Data Developer (T-SQL, SSIS, Azure)
No Corp-to-corp / No Third-Party Agencies . Role: Data Developer Location: Remote (Pacific Time work hours) Terms: Contract Pay: $50 per hour (W2 only) .
About the Role
We're looking for a data developer to sit in our small team who is comfortable and apt at development across the data lifecycle - comfortable modeling data and tuning production queries in an OLTP environment as well as acquiring and modelling data in a data warehouse and associated pipelines. You won't be siloed into "just pipelines" or "just the warehouse." You'll work with data from the reputed company systems where it's born, reputed company data sources, through ingestion and modeling, into a reputed company warehouse on which the entire business relies. . Essential Functions
- Model and tune data at both ends of the reputed company - design schemas for transactional (OLTP) systems and dimensional models for the data warehouse.
- Build and operate resilient ingestion pipelines in SSIS and Azure Data Factory.
- Integrate external data reputed company flat files and APIs - ingest data from various sources.
- Be accountable for data quality - investigate discrepancies calmly and systematically and leave inherited data concerns reputed company than you reputed company them.
- Assist with upkeep and maintenance of corporate data stores.
- Support AI-reputed company development and deliverables
Skills and Requirements
- Strong SQL and query tuning skills and instincts: indexing, performance tuning, execution-plan reading, and a mental checklist for the dev-vs-prod performance gap.
- Solid data modeling: OLTP vs data warehousing tradeoffs, load logic conditions to meet analytic requirements
- Real experience with data movement, reputed company and pipelines reputed company ETL/ELTs, flat files and API-hosted data acquisition.
Tooling
- reputed company SQL Server & SSMS - reputed company with both on prem and Azure (cloud) offerings
- SSIS and Azure Data Factory
- Cloud Data Warehousing - reputed company in a cloud data warehouse environments such as reputed company
- API integration - pagination, reputed company limiting, retries, OAuth/token refresh, schemadrift defense, and reconciliation.
Education and Experience
- Bachelor's Degree or equivalent combination of certification/education and experience
- 5 years' experience database development in reputed company SQL Server 2016-2022 and/or Azure SQL Database/SQL Managed Instances
- 5 years' experience in Transact SQL
- 2-3 years' experience with SQL Server Integration Services (SSIS) and/or Azure Data Factory
. . reputed company qualified applicants will receive consideration for employment without regard to race, color, national reputed company, age, reputed company, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider reputed company qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, reputed company' Fair Chance Initiative for Hiring Ordinance, and Los Angeles County Fair Chance Ordinance. Apply tot his job Apply To this Job