Capital Technology Alliance · 17 hours ago
Data Modeler
Capital Technology Alliance is seeking a Data Modeler to design, implement, and maintain robust data pipelines and architectures. The role involves collaborating with data scientists and analysts, ensuring data quality, and providing leadership and mentorship to junior staff members.
Information Technology & Services
Responsibilities
Design, implement, and maintain robust data pipelines and architectures in Alteryx Designer
Create and maintain logical data models in Oracle SQL Developer Data Modeler
Read, write, and update data
Create and maintain ETL code repository
Perform ad hoc data cleansing of data sets as needed
Develop and implement data quality control procedures to ensure the accuracy, completeness, and consistency of environmental data
Define data quality standards and metrics
Execute procedures to monitor data quality
Identify data issues and propose remediation plans
Optimize data processing workflows and algorithms for efficiency, scalability, and reliability
Ensure compliance with data privacy regulations and security best practices in data handling, storage, and transmission
Stay current with emerging technologies, tools, and methodologies in data engineering and environmental science
Collaborate with data scientists and analysts to optimize models and algorithms for data quality, security, and governance
Monitor and tune data systems, identify and resolve performance bottlenecks, and implement caching and indexing strategies to enhance query performance
Transform raw data into a usable format by applying data cleansing, aggregation, filtering, and enrichment techniques
Establish the governance of data and algorithms used for analysis, analytical applications, and automated decision making
Provide leadership, guidance, and mentorship to junior staff members and colleagues, fostering a culture of continuous learning, innovation, and excellence in D&A practices
Qualification
Required
3–5 years' experience in data engineering, including designing and implementing data pipelines and ETL processes
Proficiency in programming languages such as Python and SQL
Strong analytical and problem-solving skills, with the ability to analyze complex datasets and extract actionable insights
Knowledge of relational database design and data modeling
Experience with implementing data warehouses, data lakes, or data lakehouses
Ability to establish and maintain effective working relationships with others
Ability to work independently
Ability to determine work priorities and ensure proper completion of work assignments
Ability to communicate effectively, both verbally and in writing
Bachelor's degree in Data Science, Information Systems, Business Administration, or related studies, or equivalent work experience
Preferred
5–10 years' experience with Alteryx Designer
Familiarity with environmental science, water quality, or related fields
Experience with business intelligence tools such as Qlik Sense
Company
Capital Technology Alliance
At Capital Technology Alliance, we are committed to pioneering the future of technology consulting.
H1B Sponsorship
Capital Technology Alliance has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
Funding
Current Stage
Early StageCompany data provided by crunchbase