SUMMARYThe Data Engineer is a hybrid role, combining the core competencies of data engineering with business intelligence techniques to support our client's reporting needs with high agility. The role works closely with Information Analysts to plan and support the creation of reports, analysis, extracts, and data marts that feed directly into Power BI. This position is a subject matter expert in SQL, Python, and data processing within cloud environments (Snowflake, Azure, AWS), but also understands both Power BI and the marketing platforms that the source data derives from for Quality Assurance purposes. This role works to automate ad hoc processes, document ETL steps, and manage database schemas as well as provide leadership and expertise to their Data Engineering colleagues and external stakeholders. The Data Engineer 3 mentors junior level staff by performing training, code reviews, and providing feedback to improve their deliverables.KEY OUTCOMES & RESPONSIBILITIESKey Outcome:IMPROVED ORGANIZATION & PRODUCTIVITYEffective data management fuels organization, productivity, and automation. Enabling internal consumers' access to trusted data for running queries, developing strategic insights, and delivering standardized outputs. Adding value to our external customers and improving the bottom line.Key Responsibilities:Collaborates with their Director and takes the lead on projects with both internal and external stakeholders to capture requirements, architect, scope, standardize, and document Butler/Till's data frameworks.Architects and writes scripts for the creation, support, and automation of standardized, scalable, and client-specific data marts.Observe and voices opportunities where work with other departments would create solutions to improve agency efficiency.Works closely with B/T's Analysts, Media, and Account teams to understand our client's data needs and the standardization of campaign/ad naming conventions across clients.Maintains documentation on existing data policies, data dictionaries, metadata and ETL processes and creates proof of concept (POC) designs for strategic initiatives.Key Outcome:INCREASED RELIABILITYData Engineering minimizes potential errors by establishing processes and policies for usage and building trust in the data being used to make decisions across the organization. With reliable, up-to-date data, our teams can respond more efficiently to market changes and customer needs.Key Responsibilities:Designs automated QA processes of data, acting as a 1st line of defense for data integrity.Partners with Analytics for resolving tickets and processing files.Designs and maintains data flows in 3rd party applications that monitor data inconsistencies and deficits and build automated alerts to the team for corrective action.Act as a subject matter expert with respect to B/T's data deliverables as well as advise Campaign Analytics and Marketing Science with utilization strategies of data from our marketing platforms (Google, Facebook, etc.).Provides guidance and training to junior level Data Engineers on QA best practices with live code reviews.Key Outcome:REDUCED RISKEffective data engineering protects our enterprise from data losses, thefts, and breaches with authentication and encryption tools. Strong data security ensures that vital company information is backed up and retrievable should the primary source become unavailable. Also, security becomes more important if data contains personally identifiable information that must be carefully managed to comply with consumer protection laws.Key Responsibilities:The Data Engineer is familiar with data collection policies, both nationally and internationally (i.e. CCPA (California Consumer Privacy Act), GDPR).Recommends policies and standards for all supported data processes.Provides directions on which data, processes, and database code to troubleshoot for security concerns and designs policies, code, and processes to close security gaps.Key Outcome:SCALABILITYData management best practices allow organizations to effectively scale their usage of data with repeatable processes to keep data and metadata up to date. When processes are easy to repeat, organizations save time, money, and gain efficiency.Key Responsibilities:Subject matter expertise on the available data for analytics, analysis, and modeling, working closely with Information Analysts and Leadership to create strategic data marts that are easily repeatable for new and existing initiatives.Expertise in no/low code solutions (i.e. Microsoft Power Automate, Excel), SQL, and Python to support scalable, full life cycle solutions to meet business needs.Engages with vendors and internal stakeholders to explore opportunities to enhance the existing tech stack. Creates well-documented requirements for internal or external stakeholders.Orchestrates tests for new software functionality (internal or external) and works with their Director to organize, document and communicate agency-wide recommendations for future-proofing B/T's offering.Works with internal stakeholders to determine current and future needs and brings them to the Data Engineering team for future projects.RequirementsREQUIREDBachelor's degree in Computer Science, Information Technology, Statistics, Mathematics, Finance, or Economics.5-7 years of data engineering experience.Detail-oriented with strong organizational, communication, computer, and office procedure skills.Mastery knowledge of SQL, database schemas, and analytics data marts.Expertise working with both normalized and unnormalized data structures.Experience with data discovery, analytics, and BI software (e.g., Tableau, Qlik, PowerBI).Mastery in Git and/or version control software (e.g., GitHub, GitLab, BitBucket).Experience setting up CI/CD pipelines.Experience working with Snowflake with admin-level permissions.2+ years of experience working with cloud environments (Azure, AWS, etc.), managing permissions, storage, and database configurations that balance cost with performance needs.4+ years of experience in object-oriented programming languages (e.g., Python) and willingness to expand skills.Experience working in an agile team environment and using project management software (e.g., Jira, Wrike, Asana)Ability to understand and anticipate risks/dependencies across deliverables.Willingness to continuously learn and develop skill sets.1+ years of experience mentoring junior-level resources.PREFERREDFamiliarity with SaaS systems (i.e., Datorama, Ascend).Experience working with Kubernetes.Experience developing a data warehouse infrastructure.Passion for problem-solving and providing workable solutions.Strong analytical and reasoning skills with an ability to visualize processes and outcomes.CORE COMPETENCIESCUSTOMER FOCUS/CLIENT INTIMACY: seeking to understand client business challenges/needs and delivering continuous value to our clients.COLLABORATIVE: working with teams and across the organization with ease.OWNER AGILITY: able to continuously learn and quickly adapt to changing circumstances.RESULTS DRIVEN: accepts accountability to deliver business outcomes, even under changing circumstances. Delivers on commitments.DISCIPLINED: Thinks, plans, and prioritizes work on an ongoing basis, plans and aligns with key team members before acting.At Butler/Till, we take immense pride in our independent, women-owned and led status, our unwavering commitment to a purpose-driven approach, and our unique structure as a 100% employee-owned company.Our dedication to Diversity, Equity, Inclusion, and Belonging (DEIB) is a cornerstone of our culture. We believe that the diversity and inclusivity of our workforce are sources of strength. As you become part of our community, you'll discover that we are dedicated to creating a positive impact, not only for our clients but also for the communities where we live and work.WORK ENVIRONMENT & PHYSICAL DEMANDSThe work environment and physical demands characteristics described here are representative of those an employee encounters while performing the essential functions of this job, typically in an office setting or in a home office. An employee in this role may be in a stationary position, often standing or sitting for prolonged periods and using office equipment and computers. The noise level in the office environment is usually moderate. (I.e., business office with computers and printers, light foot traffic, etc.).Reasonable accommodation may be requested to enable individuals to perform the essential functions.EEO DISCLAIMERButler/Till is an Equal Opportunity Employer to all employees and applicants and prohibits discrimination and harassment of any kind without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.This applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.#J-18808-Ljbffrby Jobble

If you are looking for a career at a dynamic company with a people-first mindset and a deep culture of growth and autonomy, ACV is the right place for you! Competitive compensation packages and learning and development opportunities, ACV has what you need to advance to the next level in your career. We will continue to raise the bar every day by investing in our people and technology to help our customers succeed. We hire people who share our passion, bring innovative ideas to the table, and enjoy a collaborative atmosphere.Who we are:ACV is a technology company that has revolutionized how dealers buy and sell cars online. We are transforming the automotive industry. ACV Auctions Inc. (ACV), has applied innovation and user-designed, data driven applications and solutions. We are building the most trusted and efficient digital marketplace with data solutions for sourcing, selling and managing used vehicles with transparency and comprehensive insights that were once unimaginable. We are disruptors of the industry and we want you to join us on our journey. ACVs network of brands includes ACV Auctions, ACV Transportation, ClearCar, MAX Digital and ACV Capital within its Marketplace Products, as well as, True360 and Data Services.At ACV we focus on the Health, Physical, Financial, Social and Emotional Wellness of our Teammates and to support this we offer:Multiple medical plans including a high deductible health plan that costs $0 out of your paycheckCompany-sponsored (paid) Short-Term Disability, Long-Term Disability, and Life InsuranceComprehensive optional benefits such as Dental, Vision, Supplemental Life/AD&D, Legal/ID Protection, and Accident and Critical Illness InsuranceGenerous paid time off options, including vacation time, sick days, Company holidays, floating holidays, parental leave, bereavement leave, jury duty leave, voting leave, and other forms of paid leave as required by applicable law or regulationEmployee Stock Purchase Program with additional opportunities to earn stock in the CompanyRetirement planning through the Companys 401(k)Who we are looking for:We are seeking a highly skilled Engineer IV in Data Engineering with a strong foundation in computer science and excellent problem-solving skills. You will be responsible for maintaining and extending our database operations, optimizing SQL queries, and designing scalable data services.What you will do:Actively and consistently support all efforts to simplify and enhance the customer experience.Maintain and extend (as required) existing database operations solution for backups, index defragmentation, data retention, etc.Troubleshoot any SQL Server or ETL stack outages during our operational support window.Triage any issues with data stack (SSIS, C#, Web APIs).Support development, integration, and stage SQL Server environments for application development and data science teams.Ensure that new database development meets company standards for readability, reliability, and performance. Work with internal teams on transactional and analytical schema design.Collaborate with software and DevOps engineers to design scalable services, plan feature roll-out, and ensure high reliability and performance of our products.Architect and build entire services including but not limited to; data modeling, storage, message brokers, protocols and interfaces.Design, build and maintain complex systems that can scale rapidly with little maintenance.Conduct code reviews, develop high-quality documentation, and build robust test suites.Own the overall performance of products and services within a defined area of focus.Be empowered to lead and complete software projects with minimal guidance from managers.Lead team discussions to define technical requirements on new and current products.Respond-to and troubleshoot highly complex problems quickly, efficiently, and effectively.Mentor junior engineers.Perform additional duties as assigned.What you will need:Bachelor's degree in Computer Science, Information Technology, Computer Information Systems, Management Information Systems, or similar5 years' building & supporting the database-tier of SaaS web applications.Ability to read, write, speak, and understand English.Expert understanding of SQL query execution fundamentals and query optimization principles.Experience maintaining and extending an existing codebase, adapting to pre-existing patterns and tracing the codes path of execution.ETL workflow implementation (SSIS, Airflow, C#, Python)Experience working with Cloud Services (AWS RDS, S3, SQS, SNS)Experience working with NoSQL data stores (MongoDB)Experience writing unit and integration testing (DBT, C#)Expert SQL and data-layer development experience; OLTP schema design.Experience integrating 3rd-party APIs, implementing authentication & authorization and developing asynchronous data flows.Nice to HaveOLAP schema design experience.Experience with Airflow, Snowflake, etc.Experience with DBTCompensation:$124,000.00 - $152,000.00annually. Please note that final compensation will be determined based upon the applicant's relevant experience, skillset, location, business needs, market demands, and other factors as permitted by law.No immigration or work visa sponsorship will be provided for this position. #LI-AM3Our ValuesTrust & Transparency | People First | Positive Experiences | Calm Persistence | Never SettlingAt ACV, we are committed to an inclusive culture in which every individual is welcomed and empowered to celebrate their true selves. We achieve this by fostering a work environment of acceptance and understanding that is free from discrimination. ACV is committed to being an equal opportunity employer regardless of sex, race, creed, color, religion, marital status, national origin, age, pregnancy, sexual orientation, gender, gender identity, gender expression, genetic information, disability, military status, status as a veteran, or any other protected characteristic. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements. If you have a disability or special need that requires reasonable accommodation, please let us know. For information on our collectionand use of your personal information, please see our Privacy Notice. Apply Now#J-18808-Ljbffrby Jobble

Overview: The Data Engineer is responsible for the technology and data environment used to provide data development, support and administration for the Business Intelligence and Analytics platform, for reporting and analytics for Heritage Christian Services. A data engineer will work on extracting, integrating, and migrating data across new and existing databases, facilitating advanced analytics and data processing capabilities. Pay for this position: $58461 - $70862 / year The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to departmental budgets, qualifications, experience, education, licenses, specialty, and training. The above range represents the organization's good faith and reasonable estimate of the range of possible compensation at the time of posting Responsibilities: <ul><li>Advanced Collaboration: Define and lead projects in collaboration with Data Scientists and Engineers to enhance data workflows, implementing cutting-edge solutions to meet complex data challenge</li><li>Build data pipelines: Managed data pipelines consist of a series of stages through which data flows (for example, from data sources or endpoints of acquisition to integration to consumption for specific use cases). Data pipelines must be created, maintained, and optimized as workloads move from development to production for specific use cases. Architecting, creating, and maintaining data pipelines will be the primary responsibility of the data engineer.</li><li>Data Governance: Spearhead the development and enforcement of data management practices, ensuring the highest quality of data in our data lake and compliance with data privacy standards</li><li>Collaborate with Business Intelligence and Analytics team to share knowledge and improve data quality.</li><li>Drive Automation through effective metadata management: The Data Engineer will be responsible for using innovative and modern tools, techniques, and architectures to automate the most-common, repeatable and tedious data preparation and integration tasks to minimize manual and error-prone processes and improve productivity. </li><li>Participate in ensuring compliance and governance during data use:. Data engineer should work with data governance teams (and information stewards within these teams) and participate in vetting and promoting content created in the agency for governance and compliance.</li></ul> Qualifications: <ul><li>A Bachelor's degree in Computer Science or Information Systems </li><li>3-5 years of IT experience</li><li>Experience with Data Warehousing, Data Modeling, Semantic Model Definition or Star Schema construction, required </li><li>Hands-on delivery experience of end-to-end cloud data analytics solutions within Azure or AWS, required </li><li>Knowledge of Microsoft SQL Servers, Azure Synapse or Azure SQL instance</li><li>Experience with one or more of the following C# (Programming Language); Java (Programming Language); Python (Programming Language); SQL (Programming Language) required for sophisticated data processing and API development </li><li>Advanced proficiency in relational database modeling, Data Mart design, SQL development, and performance tuning. Must be expert at SQL coding and troubleshooting.</li><li>Preferably working knowledge of Agile Methods and enterprise Cloud Integration</li><li>Experience with Other diagnosing system issues, engaging in data validation, and providing quality assurance testing</li><li>Excellent communication skills (both written and verbal)</li><li>Excellent interpersonal and technical support skills</li><li>Excellent organizational skills, accuracy and attention to detail</li><li>Strong analytical and problem-solving skills</li><li>Ability to work in a collaborative team environment and ability to complete work within demanding time-lines</li><li>Commitment to effectively handle confidential information</li></ul>Our Commitment to Equity and Justice We believe that people are entitled to dignity, respect, equity and justice. We champion a society that removes barriers. We reject racism and discrimination of any kind. We protest systemic and political inequities that marginalize people, recognizing that there is a history of structural racism in the United States. We will continue to learn and change to achieve justice. We know that strength comes from unity.

Data Engineer Jobs in Rochester, NY

Data Engineer Iii
April 22, 2024

Data Engineer Iv
April 22, 2024

Data Engineer Iii
April 21, 2024

Data Engineer Iii
April 20, 2024

Data Engineer
April 16, 2024

Data Engineer
April 12, 2024

Data Engineer Remote Req 598
April 7, 2024

Data Engineer
April 5, 2024

Quick filters

Top companies

Data Engineer Jobs in Rochester, NY

Data Engineer IiiApril 22, 2024

Data Engineer IvApril 22, 2024

Data Engineer IiiApril 21, 2024

Data Engineer IiiApril 20, 2024

Data EngineerApril 16, 2024

Data EngineerApril 12, 2024

Data Engineer Remote Req 598April 7, 2024

Data EngineerApril 5, 2024