Data Warehouse Developer - ConsultNet
New York, NY
About the Job
Client: Confidential
Contract to Hire: 3-6 months
100% Remote
Pay: $55/hr on W2
We're looking for a passionate Data Warehouse Engineer to join our team and drive our data operations to new heights. In this role, you'll be instrumental in building and maintaining a robust data warehouse that supports large-scale data activities across various sources. You'll collaborate closely with Business Analysts, Data Scientists, and Sales to identify and address data and reporting needs.
Your expertise in cloud data warehousing, particularly with Azure services, is essential. You'll be adept at data integration methodologies (ELT/ETL) and skilled in data modeling across different formats. Proficiency in SQL and Python for data movement and processing is a must. Experience with Azure, Apache Spark, and Microsoft Fabric will be highly valued.
Key Responsibilities:
- Design and develop new data products tailored to business requirements.
- Maintain and enhance the internal data warehouse and reporting systems to maximize their impact.
- Implement QA processes for comprehensive testing from data ingestion to visualization.
- Work closely with stakeholders to define data and reporting needs.
- Create and maintain efficient, testable data pipelines in Python.
- Elevate the data warehouse by improving data timeliness and solidifying reusable data assets.
- Develop visualizations and reports using tools like SSRS and Tableau.
- Utilize version control systems (e.g., Azure DevOps) and agile project management tools (e.g., Jira).
- Transform data into traditional data warehouse schemas and ensure high-volume database system support.
- Proficient in designing data warehouses using Redshift.
- Strong programming skills in SQL and Python.
- Deep understanding of SQL-based Big Data systems and modern ETL tools.
- Mastery of database and data warehouse methodologies, from transactional databases to dimensional data modeling.
- Excellent problem-solving skills and ability to work both independently and in a team environment.
- Experience with SSIS or similar ETL tools.
- Strong understanding of relational database structures, theories, principles, and practices.
Welcome to ConsultNet and the family of companies, Tekne, SaltClick, TechBridge, and OmniMedia. As a premier national provider of technology talent and solutions, our expertise spans across project services, contract-to-hire, direct placement, and managed services both onshore and nearshore.
Celebrating more than 25 years of partnership with a diverse client base, we've crafted rewarding opportunities for our consultants, fostering high-performing teams that deliver impactful results.
Over the last few years thousands of consultants have found their calling with us in roles that have made a meaningful impact on their lives, enhanced their career, challenged them, and propelled them towards achieving their personal and professional goals. At the ConsultNet family of companies, we believe effective communication is crucial in aligning the right job with your unique skills and professional aspirations. To us, it's all about the personal approach we take and the values we uphold.
Our comprehensive service offerings cover a wide range of technology positions across key markets nationwide. Client more at www.consultnet.com .
We champion equality and inclusivity, proudly supporting an Equal Opportunity Employer policy. We welcome applicants regardless of Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other status protected by law.