Job Closed
This listing is no longer active.
Data Warehouse Engineer - Information Technology Services
Location
United States
Posted
101 days ago
Salary
$87.4K - $127K / year
Seniority
Mid Level
Job Description
Data Warehouse Engineer - Information Technology Services
Cal Poly
Job Summary Under general supervision of the Manager of Applications Engineering, the Data Warehouse Engineer position is responsible for designing, developing, documenting, and maintaining the University’s enterprise data warehouse. This includes working with campus stakeholders and other data consumers to determine requirements, design solutions, and model data. Primary activities include the design, implementation, testing, documentation and support of data models, programs, data pipelines, and scripts that produce appropriate and useful business intelligence capabilities for the campus community. This role involves developing and supporting methods to integrate data with the campus computing infrastructure, utilizing current technologies and DevOps philosophies. #CalPolyITS This position is eligible for remote work pursuant to Cal Poly’s Telecommuting and Remote Work Guidelines and the CSU policy requiring that all work be performed within the State of California. Department Summary Information Technology Services (ITS) is a fast-moving team that is responsible for helping Cal Poly achieve academic excellence through developing and implementing learning, teaching, and administrative solutions which leverage technology that align with strategic goals and objectives. With a focus on continuous improvement, ITS fosters innovation, supports continuous learning, and develops people to their full potential. Our team of more than 170 professionals works in a DevOps environment to shape the technology landscape at Cal Poly. Key Qualifications - Demonstrated experience building required infrastructure for optimal extraction, transformation and loading of data from various data sources using AWS-specific and general relational database technologies. - Demonstrated experience designing, building and optimizing data sets, data pipelines and architectures. - Demonstrated experience designing, developing and supporting data warehouse star schema models and applications. - Demonstrated skills using database/query languages to store, manipulate, and retrieve data (e.g., MySQL, Oracle, MSSQL, PostgreSQL, or Aurora). - Demonstrated programming skills using modern languages (e.g., Python). Education and Experience Equivalent to a bachelor’s degree in a related field and four years of relevant experience. Additional experience which demonstrates acquired and successfully applied knowledge and abilities shown above may be substituted for the required education on a year-for-year basis. An advanced degree in a related field may be substituted for the required experience on a year-for-year basis. Salary and Benefits Anticipated Hiring Range: $98,436 - $119,988 Per Year Classification Range: $87,408 - $127,332 Per Year Factors in determining the appropriate compensation for a role include experience, skills, knowledge, abilities, education, licensure and certifications, and other business and organizational needs. The Anticipated Hiring Range referenced in the job posting is the budgeted salary or hourly range that the University reasonably expects to pay for this position. The Classification Range may be broader than what the University anticipates paying for this position, based on internal equity, budget, and collective bargaining agreements (when applicable). Cal Poly offers a best-in-class benefits program, including health, dental and vision insurance, retirement participation in the Public Employees' Retirement System, and educational benefits for eligible employees. See our benefits website for additional information. Cal Poly Cal Poly is a nationally-ranked public university located in San Luis Obispo, California, and known for its Learn by Doing philosophy. Each year more than 20,000 top-tier students come to San Luis Obispo to put knowledge into action, taking their learning outside the classroom as they prepare for careers in engineering, agriculture, science, business, humanities and the built environment. Cal Poly’s hands-on philosophy, small class sizes and close student-faculty mentorships result in graduates ready from day one to impact their communities, California and the world. For more information, visit calpoly.edu. Equal Opportunity and Excellence in Education and Employment This position is open and available to all regardless of race, sex, color, ethnicity or national origin. Consistent with California law and federal civil rights laws, Cal Poly provides equal opportunity in education and employment without unlawful discrimination or preferential treatment based on race, sex, color, ethnicity, or national origin. Our commitment to equal opportunity means ensuring that every student and employee has access to the resources and support they need to thrive and succeed in a university environment and in their communities. Cal Poly complies with Title VI of the Civil Rights Act of 1964, Title IX of the Education Amendments of 1972, the Americans with Disabilities Act (ADA), Section 504 of the Rehabilitation Act, the California Equity in Higher Education Act, California’s Proposition 209 (Art. I, Section 31 of the California Constitution), other applicable state and federal anti-discrimination laws, and CSU’s Nondiscrimination Policy. We prohibit discriminatory preferential treatment, segregation based on race or any other protected status, and all forms of discrimination, harassment, and retaliation in all university programs, policies, and practices. Cal Poly is a diverse community of individuals who represent many perspectives, beliefs and identities, committed to fostering an inclusive, respectful, and intellectually vibrant environment. We cultivate a culture of open dialogue, mutual respect, and belonging to support educational excellence and student success. Through academic programs, student organizations and activities, faculty initiatives, and community partnerships, we encourage meaningful engagement with diverse perspectives. As a higher education institution, we are dedicated to advancing knowledge and empowering individuals to reach their full potential by prioritizing inclusive curriculum development, faculty and staff training, student mentorship, and comprehensive support programs. At Cal Poly, excellence is built on merit, talent, diversity, accessibility, and equal opportunity for all. Supplemental Information Satisfactory completion of a background check (including a criminal records check) is required for employment. Cal Poly will make a conditional offer of employment, which may be rescinded if the background check reveals disqualifying information, and/or it is discovered that the candidate knowingly withheld or falsified information. Current employees who are offered positions on campus will be required to undergo a background check for any position where a background check is required by law or that Cal Poly has designated as sensitive. Failure to satisfactorily complete the background check may affect the continued employment of a current CSU employee who was conditionally offered the position. The person holding this position is considered a 'mandated reporter' under the California Child Abuse and Neglect Reporting Act and is required to comply with the requirements set forth in CSU Executive Order 1083 as a condition of employment. Cal Poly, San Luis Obispo is not a sponsoring agency for staff or management positions. Applicants for staff and management positions must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time. Positions are posted for a minimum of 14 calendar days.
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
• Design and manage scalable data ingestion pipelines using Azure Data Factory and Azure Service Bus for batch and near real-time processing • Implement Bronze, Silver, and Gold data layer transformations using Databricks (PySpark, SparkSQL) within a lakehouse architecture • Integrate structured, semi-structured, and unstructured data sources using formats such as Parquet, Avro, and JSON into ADLS Gen2 • Establish data quality frameworks and validation processes using Databricks and Azure Data Factory • Configure RBAC and ACL-based access controls to secure sensitive datasets and ensure compliance • Manage credential security with Azure Key Vault and enforce governance standards across data platforms • Automate pipeline orchestration using Databricks Workflows and CI/CD tools such as Azure DevOps, GitHub Actions, and Terraform • Monitor pipeline health and performance using Azure Monitor, logging, and alerting to meet SLA requirements • Optimize ADLS storage performance and manage cloud costs using Azure Cost Management best practices
Data Engineer
MotiveMotive combines IoT hardware with AI-powered applications to connect and automate physical operations.
Who we are: Motive empowers the people who run physical operations with tools to make their work safer, more productive, and more profitable. For the first time ever, safety, operations and finance teams can manage their drivers, vehicles, equipment, and fleet related spend in a single system. Combined with industry leading AI, the Motive platform gives you complete visibility and control, and significantly reduces manual workloads by automating and simplifying tasks. Motive serves nearly 100,000 customers – from Fortune 500 enterprises to small businesses – across a wide range of industries, including transportation and logistics, construction, energy, field service, manufacturing, agriculture, food and beverage, retail, and the public sector. Visit gomotive.com to learn more. About the Role: As a Data Engineer on our BI team, you’ll be a key player in Motive’s growth, delivering the data infrastructure for the AI era. You’ll act as the essential link between complex data and key business domains, delivering the high-quality datasets and semantic models that drive global strategy. This is an exciting opportunity to implement cutting-edge tooling, leverage AI to enhance your workflow, and master a modern data stack in a fast-evolving environment. This is the perfect role for a "jack of all trades" data practitioner. You’ll design data models, build robust pipelines, manage DevOps and automated systems, and implement AI-driven data tooling. You’ll even get your hands dirty building dashboards and performing deep-dive analysis. If you love working full-stack and owning the entire data lifecycle, you’ll love this role. What You'll Do: - Collaborate & Strategize: Partner closely with business stakeholders to understand their challenges and design end-to-end architecture that solves complex business problems. - Build & Maintain Data Models: Design, develop, and own robust, efficient, and scalable data models in Snowflake and Iceberg using dbt and advanced SQL. - Orchestrate & Automate: Build and manage reliable data pipelines and CI/CD workflows using tools like Airflow, Python, and Terraform to ensure data is fresh, trustworthy, and infrastructure is version-controlled. - Champion Data Quality: Implement rigorous testing, documentation, and data governance practices to maintain a single source of truth. - Enable Analytics & Workflows: Act as the Product Owner and Tech Lead for your data domains, taking responsibility for the end-to-end data product delivery– from raw ingestion to data models enabling analytics and data apps in tools like Tableau and Retool. - Innovate with AI: Help us build our next-generation data infrastructure by integrating AI capabilities (like Snowflake Cortex AI) to democratize analytics and empower the business. - Architect Observability: Implement monitoring and alerting frameworks (e.g., dbt packages or Monte Carlo monitors) to proactively catch "silent" data failures before stakeholders do. What We're Looking For: - 6+ years of experience in Analytics Engineering, Data Engineering, or a similar role. - Deep expertise in SQL and developing complex data models for analytical purposes (e.g., dimensional modeling). - Hands-on experience with: - Data Warehousing: High proficiency in Snowflake (preferred) and experience with Open Table Formats like Iceberg. - Data Transformation: dbt - Orchestration & ETL: Airflow, Fivetran, Airbyte - Cloud Platform: AWS - Programming/Ingestion: Python - Infrastructure as Code: Terraform - AI-Augmented Development: Proficiency using AI coding assistants (Cursor, Copilot, or Claude) to accelerate development and automate routine tasks. - A strong analytical mindset with a proven ability to solve ambiguous business problems with data. - Excellent communication skills and experience working cross-functionally. - Self-starter with the ability to self-project manage work - A user focus with the ability to understand how a data consumer will use the data products you build Bonus Points (Nice-to-Haves) - Experience building semantic models for natural language querying - Direct experience with advanced Snowflake features (e.g., Snowpark, Cortex AI). - Experience building visualizations and dashboards in tools like Tableau, Retool, or Thoughtspot. Pay Transparency Your compensation may be based on several factors, including education, work experience, and certifications. For certain roles, total compensation may include restricted stock units. Motive offers benefits including health, pharmacy, optical and dental care benefits, paid time off, sick time off, short term and long term disability coverage, life insurance as well as 401k contribution (all benefits are subject to eligibility requirements). Learn more about our benefits by visiting Motive Perks & Benefits. The compensation range for this position will depend on where you reside. For this role, the compensation range is: Canada $133,000—$182,000 CAD Creating a diverse and inclusive workplace is one of Motive's core values. We are an equal opportunity employer and welcome people of different backgrounds, experiences, abilities and perspectives. Please review our Candidate Privacy Notice here. UK Candidate Privacy Notice here. The applicant must be authorized to receive and access those commodities and technologies controlled under U.S. Export Administration Regulations. It is Motive's policy to require that employees be authorized to receive access to Motive products and technology.
Data Engineer
Cormac CorporationAt CORMAC, we leverage the power of data management and analytics to enable our customers to achieve their strategic goals. With over 20 years of experience in health information technology (HIT), human-centered design principles, and Agile development methodologies, CORMAC delivers complex digital solutions to solve some of the most challenging problems facing public healthcare programs today.
Role Description CORMAC is seeking a skilled Data Engineer to manage and optimize our data for powerful analytics and reporting. You will play a key role in building and maintaining scalable data processing pipelines while ensuring data integrity, security, and accessibility for business-critical applications. - Develop and maintain data processing applications using Apache Spark and Scala to process large-scale datasets efficiently. - Monitor and optimize database performance, including indexing, query optimization, and load balancing, to ensure high availability and low-latency data access. - Design and implement robust, scalable, and efficient database structures to support applications and data analytics. - Deploying and managing data infrastructure on AWS. - Assist in the migration of data between systems, including database upgrades, platform changes, and ETL processes for data integration. - Leveraging cloud-native services for data processing and storage. - Optimizing costs while maintaining performance and scalability. - Applying various transformations like data cleansing, aggregation, and enrichment. - Monitor data quality metrics and perform data cleansing as necessary. - Work with Product Owners and Business Analysts to refine user stories for data ingestion, processing, and reporting features. Qualifications - Bachelor’s in Computer Science, Computer Engineering, Information Systems, or related field. - 3+ years of experience as a Data Engineer or similar role. - 2+ years of experience working with Apache Spark, Scala, and Spark SQL. - Must have the ability to obtain a Public Trust (Tier 1) Security Clearance. - Experience with cloud platforms such as AWS, Google Cloud, or Azure, utilizing cloud services for data storage, processing, and retrieval. - Knowledge of data warehousing, data lakes, and cloud computing. - Familiarity with machine learning algorithms. - Knowledge of ETL processes and data modeling techniques. - Familiarity with ETL tools, REST APIs, and data integration techniques. - Understanding of data security and compliance best practices. - Ability to develop clear, efficient, scalable solutions for complex problems. - Understanding of data warehousing solutions and database architecture principles. - Effective communication and teamwork abilities. - Strong problem-solving skills and attention to detail. Requirements - Experience using Airflow, DBT, Postgres, Databricks, Amazon EMR & RDS. - Working experience on an Agile/Scrum or SAFe development team. Location Leesburg, VA Work Arrangement 100% Remote Benefits At CORMAC, we leverage the power of data management and analytics to enable our customers to achieve their strategic goals. With over 20 years of experience in health information technology (HIT), human-centered design principles, and Agile development methodologies, CORMAC delivers complex digital solutions to solve some of the most challenging problems facing public healthcare programs today. - As a US Federal Government contractor in the public healthcare sector, our work is impactful and cutting-edge while being performed in a supportive, collaborative, and welcoming environment. - We offer flexible work schedules with remote, hybrid, or fully in-person workplace options to empower our employees to decide the workplace most suitable for them. - At CORMAC, we have a highly diverse workforce and believe a work environment is a place where creativity, collaboration, enthusiasm, and innovation happen, regardless of location. Company Description US Citizenship Required/E-Verify Participation/EEO As an Equal Employment Opportunity employer, CORMAC provides equal employment opportunity to all employees and applicants without regard to an individual's protected status, including race/ethnicity, color, national origin, ancestry, religion, creed, age, gender, gender identity/expression, sexual orientation, marital status, parental status, including pregnancy, childbirth, or related conditions, disability, military service, veteran status, genetic information, or any other protected status.
Data Steward Hiring ASAP
AssistRxSpecialty therapy initiation and patient support company delivering informed access and improved outcomes.
The Data Steward is responsible for ensuring the quality, integrity, and appropriate use of data across the organization. This role plays a key part in supporting enterprise data governance initiatives by executing day-to-day stewardship activities, which may span master data, transactional data, and reference data. The Data Steward collaborates with both business and technical teams to ensure trusted and well-governed data assets are available for critical decision-making. DUTIES AND RESPONSIBILITIES · Review and validate enterprise data to ensure completeness, accuracy, and alignment with defined data standards. · Identify, investigate, and resolve data quality issues including duplicates, inconsistencies, and missing or invalid values. · Collaborate with business users and data analysts to refine data requirements and enforce data standards. · Participate in data quality reviews and assist with implementing corrective and preventative actions. · Manage stewardship workflows for data quality exceptions, including tasks related to matching, merging, or enrichment. · Support onboarding and validation of new data sources across transactional and reference systems. · Partner with data governance council to maintain and enforce policies related to data access, lineage, classification, and quality. · Document business metadata, data definitions, and stewardship procedures. · Assist with data profiling and root cause analysis across operational and analytical datasets. · Use tools such as Excel, SQL, and MDM or data quality platforms (e.g., Reltio) to monitor and manage data quality. · Provide support for data audits, regulatory reporting, or operational processes dependent on high-quality data. · Communicate with cross-functional stakeholders to resolve data issues and gather feedback. · Stay current on data governance and stewardship best practices, especially in regulated industries such as healthcare. · Perform other related duties as assigned by management. SUPERVISORY RESPONSIBILITIES - This job has no direct supervisory responsibilities.
