Etl Developer Salary in Chicago, IL

Role: Data Management DeveloperLocation - Chicago IL2 Lead position ( 12 plus Years of Experience)6 Senior Developer ( 8-12 years)4 Developer ( 5 to 8 years)Job Summary: The Data Management Specialist will be responsible for managing and optimizing our organization's data infrastructure, ensuring data quality, and implementing data solutions using PySpark, DataBricks, Snowflake, and/or Redshift. The ideal candidate will have a strong background in data management, programming, and cloud-based data platforms.Key Responsibilities:1. Develop and maintain data pipelines using PySpark to process and transform large volumes of data.2. Design, implement, and optimize data solutions using DataBricks for data analytics and machine learning applications.3. Manage and administer cloud-based data platforms such as Snowflake and Redshift, ensuring high availability, scalability, and performance.4. Collaborate with cross-functional teams to understand data requirements and deliver tailored data solutions.5. Implement data governance policies and procedures to ensure data quality, consistency, and security.6. Monitor and troubleshoot data issues, ensuring timely resolution and minimal impact on business operations.7. Stay updated with the latest trends and technologies in data management, cloud computing, and big data analytics.8. Provide technical guidance and mentorship to junior data management team members.Qualifications:· Bachelor's degree in Computer Science, Information Systems, or related field; Master's degree preferred.· Minimum of 5 years of experience in data management, data engineering, or related role.· Strong programming skills in Python and experience with PySpark for data processing and analytics.· Hands-on experience with DataBricks for building and optimizing data pipelines.· Proficiency in managing and administering cloud-based data platforms such as Snowflake and/or Redshift.· Solid understanding of data modeling, ETL processes, and data warehousing concepts.· Excellent analytical, problem-solving, and communication skills.· Ability to work effectively in a fast-paced environment and manage multiple priorities.Preferred Qualifications:· Certifications in PySpark, DataBricks, Snowflake, or Redshift.· Experience with other data management tools and technologies.· Knowledge of machine learning algorithms and techniques.· Experience working in banking and payments domain

Overall PurposeIndividuals within this senior role will act as a "consultant" when interacting with stakeholders. Lead and enable complex enterprise business intelligence solutions. Critical thinkers and effective 'c-suite' liaisons who are passionate about data and practiced at translating business requirements into effective visual design. Perform in depth data analysis, cause and effect analysis based on data available to arrive at logical insights and results and provide report-outs to stakeholders.Analyze metrics across multiple data sources, understand logical inter-dependencies, articulate key performance indicators and architect word-class business and operational dashboards.Individuals in this role will proactively drive and own larger bodies of work and will be close to SME level in their assigned areas of the business.Essential Functions• Drive new and modify existing requirements for reports and dashboards based on direct interaction and consultancy with stakeholders. Apply business analyst techniques to drive requirements concurrence that inform comprehensive and actionable dashboard designs.• Evaluate internal and external customers' needs and abilities in order to provide appropriate solutions.• Provide senior level BI team guidance and serve in adjunct leadership role as required by manager.• Lead complex BI projects and ensure their complete and accurate execution with emphasis on delivering business value.• Collaborate across the organization to consolidate data landscapes, reduce development time and increase consistency among BI solutions.• Provide senior consultation and oversight of cross-functional teams to influence design, alignment and implementation of BI technical standards.• Investigate BI analytics and data management trends and guide process, platform and tools best-practices.• Drive BI advocacy by providing support, training and outreach to business teams.• Support the company's commitment to risk management and protecting the integrity and confidentiality of systems and data• The above job description is not intended to be an all-inclusive list of duties and standards of the position. Incumbents will follow instructions and perform other related duties as assigned by their supervisor.Minimum Qualifications• Education and/or experience typically obtained through completion of a Bachelor's degree in Computer Science, Information Systems, Business Management or specialized training/certification or related field.• Minimum of 8 or more years of relevant experience with at least 5 or more years of experience in fraud risk management.• Experience utilizing Tableau data connections to cloud SaaS offerings such as Salesforce, AWS or Google. Strong understanding of Tableau Server and Tableau Dashboard• Demonstrated ability with testing, problem solving and analysis• Extensive knowledge of the principle, practices and techniques of dashboard development, reporting, data modeling, ETL and systems design• Strong understanding of SQL and Business Objects tools. Strong experience working with MS Office Suite. Expert level experience working with MS SQL query language and MS Office Suite• Highly effective interpersonal, communication, and presentation skills and the ability to develop strong relationships and trust throughout all levels in the organization.• High attention to detail, strong organizational skills and exemplary analytical skills• Familiarity with Hadoop, Hive/Impala and Business Objects and Webi reports• Background and drug screenPreferred Qualifications• Experience with Splunk• Experience with LexisNexis, ThreatMetrix and/or NuDetectPhysical RequirementsWorking conditions consist of a normal office environment. Work is primarily sedentary and requires extensive use of a computer and involves sitting for periods of approximately four hours. Work may require occasional standing, walking, kneeling and reaching. Must be able to lift 10 pounds occasionally and/or negligible amount of force frequently. Requires visual acuity and dexterity to view, prepare, and manipulate documents and office equipment including personal computers. Requires the ability to communicate with internal and/or external customers.Employee must be able to perform essential functions and physical requirements of position with or without reasonable accommodation.The pay scale for this position in:Phoenix, AZ and Chicago, IL in USD per year is: $130,000 - $140,000.New York, NY and San Francisco, CA in USD per year is: $130,000 - $150,000This pay scale is subject to change and is not necessarily reflective of actual compensation that may be earned, nor a promise of any specific pay for any specific candidate, which is always dependent on legitimate factors considered at the time of job offer. Early Warning Services takes into consideration a variety of factors when determining a competitive salary offer, including, but not limited to, the job scope, market rates and geographic location of a position, candidate's education, experience, training, and specialized skills or certification(s) in relation to the job requirements and compared with internal equity (peers). The business actively supports and reviews wage equity to ensure that pay decisions are not based on gender, race, national origin, or any other protected classes.Additionally, candidates are eligible for a discretionary bonus, and benefits.Some of the Ways We Prioritize Your Health and Happiness • Healthcare Coverage - Competitive medical (PPO/HDHP), dental, and vision plans as well as company contributions to your Health Savings Account (HSA) or pre-tax savings through flexible spending accounts (FSA) for commuting, health & dependent care expenses.• 401(k) Retirement Plan - Featuring a 100% Company Safe Harbor Match on your first 6% deferral immediately upon eligibility.• Paid Time Off - Unlimited Time Off for Exempt (salaried) employees, as well as generous PTO for Non-Exempt (hourly) employees, plus 11 paid company holidays and a paid volunteer day.• 12 weeks of Paid Parental Leave• Maven Family Planning - provides support through your Parenting journey including egg freezing, fertility, adoption, surrogacy, pregnancy, postpartum, early pediatrics, and returning to work.And SO much more! We continue to enhance our program, so be sure to check our Benefits page here for the latest. Our team can share more during the interview process!Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.Early Warning Services, LLC ("Early Warning") considers for employment, hires, retains and promotes qualified candidates on the basis of ability, potential, and valid qualifications without regard to race, religious creed, religion, color, sex, sexual orientation, genetic information, gender, gender identity, gender expression, age, national origin, ancestry, citizenship, protected veteran or disability status or any factor prohibited by law, and as such affirms in policy and practice to support and promote equal employment opportunity and affirmative action, in accordance with all applicable federal, state, and municipal laws. The company also prohibits discrimination on other bases such as medical condition, marital status or any other factor that is irrelevant to the performance of our employees.

Collaborate across the enterprise to identify analytic gaps and prioritize the build of solutions. Develop new and build improvements on existing reports and dashboards using Tableau. Work with core analytic team to share data model and query needs to support analytic solutions. Build and publish customized, interactive Tableau reports and dashboards using stack bars, scatterplots, geographical maps, and other innovative plot and chart toolsResponsibilitiesDeveloping reports and analytics using data from data warehouse using Excel, SQL, Tableau and other reporting/analytics toolsWorks with partners to help guide and assist in creating a data feed according to defined specificationsProactively communicates with trading partners and clients to expedite their onboardingCommunicates directly with customer on data needs and key deadlinesResearches and identifies data quality issues reported through the trading partner or found through new file submission and work with client to create a resolutionFields ongoing, incoming partner requests and questions regarding data specificationsReviews files received for compliance with data needs, including testing files and identifying the business rules that will need to be configured in mapping toolConfigures mapping tool to support translation from source data to desired format. Includes testing of tool and providing clear documentation to internal resources and customerAnalyzes and communicates trading partner performance in their ability to meet data specifications in a timely and effective mannerAct as resident expert for data requirements/specifications internally and for the clientCommunicates data needs to the trading partner both initially and after we begin to receive files for the customerResearches, coordinates, and executes the transfer of new data feeds or data corrections with clients to ensure that continuity and level of service are maintainedRemain informed and up to speed with ongoing changes and evolution of data specsLead client/partner web-based trainings regarding data specifications and requirementsSelf-starter, an individual who is not fully dependent on direction to fulfill the functions of the roleThrives in an entrepreneurial-like environmentRequirementsExperience with ETL, analytic-based, data-driven, SSIS and Microsoft BI stackExperience with Microsoft Excel and SQL is a mustExperience with healthcare and/or pharmacy data is preferredPrevious client-facing experience is a mustMust be extremely responsive, able to work under pressure in crisis with a strong sense of urgencyBenefitsSupportive, progressive, fast-paced environmentCompetitive pay structureMatching 401(k) with immediate vestingMedical, dental, vision, life, & short-term disability insuranceAssistRx, Inc. is proud to be an Equal Opportunity Employer. All qualified applicants will receive consideration without regard to race, religion, color, sex (including pregnancy, gender identity, and sexual orientation), parental status, national origin, age, disability, family medical history or genetic information, political affiliation, military service, or other non-merit based factors, or any other protected categories protected by federal, state, or local laws.All offers of employment with AssistRx are conditional based on the successful completion of a pre-employment background check.In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire. Sponsorship and/or work authorization is not available for this position.AssistRx does not accept unsolicited resumes from search firms or any other vendor services. Any unsolicited resumes will be considered property of AssistRx and no fee will be paid in the event of a hire

Description Cloud Engineer Senior Location: This position will work a hybrid model (remote and office). The Ideal candidate will live within 50 miles of one of our Elevance Health PulsePoint locations. The Cloud Engineer Senior will be responsible for delivery of end-to-end application, system development and maintenance on complex multi technology platforms within assigned client group, business unit or corporate department and utilizing various customer technology platforms. This position will be instrumental in building and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross-functional teams. The ideal candidate is an experienced data pipeline builder and data wrangler who enjoys optimizing data systems and building them from the ground up. The Cloud Engineer Senior will support our software developers, database architects, data analysts, and data scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects. How you will make an impact: Maintains active relationships with customers to determine business requirements and leads requirements gathering meetings. Owns the change request process and may coordinate with other teams as necessary. Provides technical advice and weighs in on technical decisions that impact cross functional teams. Research and may propose new technologies. Develops and owns list of final enhancements. Develops and defines application scope and objectives and prepares technical and/or functional specifications from with programs will be written. Performs technical design reviews and code reviews. May own technical testing to ensures unit test is completed and meets the test plan requirements, system testing is completed and system is implemented according to plan. Assesses current status and supports data information planning. Coordinates on-call support and ensures effective monitoring of system. Maintains technical development environment. Mentors others and may lead multiple or small to medium sized projects. Will begin to set direction at the project/service level and influences decision-making. Provides technical guidance, and mentoring. Understands the tradeoffs between technical, analytical and product needs of the technical solutions. Identifies and propose strategies around technical problems affecting team, communicates standards and gets buy-in on solutions. Facilitates group sessions to elicit complex information on requirements clarification, design sessions, code reviews and troubleshooting issues. Supports vendor evaluation. In this role the Cloud Engineer Senior will have the opportunity to: Data Pipeline Architecture : Design and implement scalable and reliable data pipelines within AWS cloud environments, leveraging technologies such as Snowflake, SQL Server, Oracle, Python, Apache Airflow, SSIS, DataStage, or Informatica. Database Management : Administer, maintain, and optimize SQL Server or Oracle databases to ensure high performance, availability, and security. ETL Development : Develop and maintain ETL processes using Python, SSIS, DataStage or Informatica to extract data from various sources, transform it according to business rules, and load it into data warehouses or data lakes. Cloud Services Management : Leverage AWS services (e.g., Amazon S3, RDS, Redshift, Lambda, Glue), and GCP to build and maintain a highly efficient data infrastructure. Performance Tuning : Monitor, identify, and rectify database performance issues. Optimize data processing and ETL jobs for maximum efficiency. Data Security and Compliance : Implement and maintain data security measures, ensuring compliance with data protection regulations and best practices in the cloud. Collaboration : Work with team members across departments to identify and implement data improvements, integrations, and new technologies to enhance the business's data ecosystem. Minimum Requirements: Requires an BA/BS degree in Information Technology, Computer Science or related field of study and a minimum of 5 years related experience; multi-dimensional platform experience; expert level experience with business and technical applications, or any combination of education and experience, which would provide an equivalent background. Preferred Skills, Capabilities, and Experiences: Strong experience with AWS cloud services related to data storage, processing, and analytics. Proficient in managing and optimizing Snowflake, SQL Server, and Oracle databases. Extensive experience with ETL tools, specifically Airflow, SSIS, DataStage, or Informatica. Solid understanding of SQL, Python, and other programming languages. Knowledge of data modeling, data governance, data security practices, and compliance frameworks. Excellent problem-solving skills and the ability to work and collaborate with teams in a dynamic and challenging environment. Healthcare experience is preferred. Please be advised that Elevance Health only accepts resumes for compensation from agencies that have a signed agreement with Elevance Health. Any unsolicited resumes, including those submitted to hiring managers, are deemed to be the property of Elevance Health. Who We Are Elevance Health is a health company dedicated to improving lives and communities - and making healthcare simpler. We are a Fortune 25 company with a longstanding history in the healthcare industry, looking for leaders at all levels of the organization who are passionate about making an impact on our members and the communities we serve. How We Work At Elevance Health, we are creating a culture that is designed to advance our strategy but will also lead to personal and professional growth for our associates. Our values and behaviors are the root of our culture. They are how we achieve our strategy, power our business outcomes and drive our shared success - for our consumers, our associates, our communities and our business. We offer a range of market-competitive total rewards that include merit increases, paid holidays, Paid Time Off, and incentive bonus programs (unless covered by a collective bargaining agreement), medical, dental, vision, short and long term disability benefits, 401(k) +match, stock purchase plan, life insurance, wellness programs and financial education resources, to name a few. Elevance Health operates in a Hybrid Workforce Strategy. Unless specified as primarily virtual by the hiring manager, associates are required to work at an Elevance Health location at least once per week, and potentially several times per week. Specific requirements and expectations for time onsite will be discussed as part of the hiring process. Candidates must reside within 50 miles or 1-hour commute each way of a relevant Elevance Health location. The health of our associates and communities is a top priority for Elevance Health. We require all new candidates in certain patient/member-facing roles to become vaccinated against COVID-19. If you are not vaccinated, your offer will be rescinded unless you provide an acceptable explanation. Elevance Health will also follow all relevant federal, state and local laws. Elevance Health is an Equal Employment Opportunity employer and all qualified applicants will receive consideration for employment without regard to age, citizenship status, color, creed, disability, ethnicity, genetic information, gender (including gender identity and gender expression), marital status, national origin, race, religion, sex, sexual orientation, veteran status or any other status or condition protected by applicable federal, state, or local laws. Applicants who require accommodation to participate in the job application process may contact [email protected] assistance.

ETL DeveloperReq number:R2369Employment type:Full timeWorksite flexibility:RemoteJob SummaryAs the ETL Developer you will support our client's compliance department to develop ETL solutions.Job DescriptionWe are looking for an ETL Developer to support our client's compliance department to develop ETL solutions. This will be a full-time 6 month contract and remote.What You'll DoWork as IT Developer in the Compliance area to develop ETL solutionsCollaborate with Project BA's & architects to design, develop based on Business RequirementsWork with IT QA Team on QA Testing & code fixesWork on Post UAT defect fixesWhat You'll NeedRequired:8+ Years of experience as ETL developer with proficiency is the following technical skillsetStrong experience with ETL tools such as Informatica, SSIS, DataStage, TimeXtenderStrong SQL, PL/SQL experienceShell scripts/ VB scripting / Python experienceBatch knowledge with any tools such as Autosys, Control-M, CybermationWell organized with the ability to manage multiple prioritiesSolid communication and interpersonal skills, ability to work on a teamAbility to drive work to completion and escalate when necessaryPreferred:Banking experience is a plusCompliance domain experience is a plusPhysical Demands Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state and local standards Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc. Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor Reasonable Accommodation StatementIf you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to [email protected] or (888) 824 - 8111.Equal Employment Opportunity Policy StatementIt is the policy of CAI not to discriminate against any employee or applicant due to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran. It is also the policy of CAI to take affirmative action to employ and to advance in employment, all persons regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran, and to base all employment decisions only on valid job requirements. This policy shall apply to all employment actions, including but not limited to recruitment, hiring, upgrading, promotion, transfer, demotion, layoff, recall, termination, rates of pay or other forms of compensation and selection for training, including apprenticeship, at all levels of employment. Employees and applicants of CAI will not be subject to harassment due to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran. Additionally, retaliation, including intimidation, threats, or coercion, because an employee or applicant has objected to discrimination, engaged or may engage in filing a complaint, assisted in a review, investigation, or hearing or have otherwise sought to obtain their legal rights under any Federal, State, or local EEO law is prohibited.

Location: REMOTESalary: $60.00 USD Hourly - $80.00 USD HourlyDescription: Our client is currently seeking a Appian Developer for a1 year+ remote contract role. The qualified candidate will have experience in the following:Experience Required:ü Full stack, SDLC using Appian (DB, PM, Front-end)ü Appian Certified Lead Developer, or equivalent, Minimum Appian level 2 certification and/or equivalent experience with a minimum of 5 years of Appian delivery is required.ü Should have experience using version 21.x and higher with current experience on supported versionü Ability to work in a team environment and autonomouslyü Experience with integrations, WebAPI is desirable, consuming Web Services (Restful, SOAP)ü Experience with various testing disciplines, unit, functional, load, performance, smokeü Experience supporting application post-deployment and analysis triaging and resolving issues.ü Hands-on creation of tempo enabled forms using SAIL. CDTs and nested CDT, creates workflows using process modeler or demonstrated ability to learnü Performs code/peer and functional reviews to ensure best practices and industry standards are being followedü Successful candidate must show individual initiative and drive to solutions, working collaboratively with development team, business Subject Matter Expertsü Relational DB experience - transact SQL, MYSQL, MariaDB, full system integrator (data layer, services, UX), reporting toolsets (Appian, SSRS, Tableau, etc.), ETL tools, and experience in Agile methodology Contact: [email protected] job and many more are available through The Judge Group. Find us on the web at www.judge.com

Incentive Comp Data Quality Tool DeveloperBCforward is currently seeking a highly motivated Incentive Comp Data Quality Tool Developer for an opportunity in Chicago, IL.Position Title: Incentive Comp Data Quality Tool DeveloperLocation: Chicago, ILExpected Duration: 12 monthsMUST HAVES: - UNIX/SHELL SCRIPTS - Oracle Exadata Senior Developer on a large Incentive Compensation project, building out our new Data Quality framework within the Collibra application. * Experience with basic Unix to be able to go debug logs, interpret/change config files etc. * Experience working on any ETL tool ( in a data warehouse platform) or data governance platform. This will help the person be able to connect the dots and understand what each data quality dimensions represent. Especially things like source to target row count/data comparison. Etc. * Experience with working on diverse databases such as ORACLE, Hadoop * Ability to run basic queries to connect to different databases and to troubleshoot issues when needed * Prior experience using a data quality tools (i.e. OWL DQ/Collibra DQ, Informatica , SAP DQ, others) * Prior infrastructure experience (i.e. installations/upgrades on a regular basis).Benefits: BCforward offers all eligible employees a comprehensive benefits package including, but not limited to major medical, HSA, dental, vision, employer-provided group life, voluntary life insurance, short-term disability, long-term disability, and 401k. About BCforward: Founded in 1998 on the idea that industry leaders needed a professional service, and workforce management expert, to fuel the development and execution of core business and technology strategies, BCforward is a Black-owned firm providing unique solutions supporting value capture and digital product delivery needs for organizations around the world. Headquartered in Indianapolis, IN with an Offshore Development Center in Hyderabad, India, BCforward's 6,000 consultants support more than 225 clients globally. BCforward champions the power of human potential to help companies transform, accelerate, and scale. Guided by our core values of People-Centric, Optimism, Excellence, Diversity, and Accountability, our professionals have helped our clients achieve their strategic goals for more than 25 years. Our strong culture and clear values have enabled BCforward to become a market leader and best in class place to work. BCforward is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against based on disability. To learn more about how BCforward collects and uses personal information as part of the recruiting process, view our Privacy Notice and CCPA Addendum. As part of the recruitment process, we may ask for you to disclose and provide us with various categories of personal information, including identifiers, professional information, commercial information, education information, and other related information. BCforward will only use this information to complete the recruitment process. This posting is not an offer of employment. All applicants applying for positions in the United States must be legally authorized to work in the United States. The submission of intentionally false or fraudulent information in response to this posting may render the applicant ineligible for the position. Any subsequent offer of employment will be considered employment at-will regardless of the anticipated assignment duration. Interested candidates please send resume in Word format Please reference job code 221974 when responding to this ad.Get job alerts by email.Sign up now!Join Our Talent Network!Job SnapshotEmployee TypeContractorLocationChicago, IL (Onsite)Job TypeBankingExperienceNot SpecifiedDate Posted04/30/2024

Location: REMOTESalary: $62.00 USD Hourly - $65.00 USD HourlyDescription: The Judge Group is currently seeking a Senior Qlik Developer to support a large federal agency. This position requires US citizenship. Please, no third parties. Specific responsibilities include, but not limited to:Strong experience in leading business intelligence projects, designing / developing analytical applications, performing data analysis/data modeling for Qlik dashboards.Ability to architect data to provide optimal performance.Must be creative, innovative, self-sufficient and resourceful.Understanding of complete data analytics stack and workflow, from ETL to data platform design to BI and analytics tools.Extensive knowledge of and experience with large-scale database technology (e.g. RedShift, BigQuery, Synapse, Vertica, Netezza, Exadata, Teradata, Greenplum, etc.).Semantic model and report development experience using common Business Intelligence or data exploration tools (e.g. Power BI, Tableau, Qlik, Oracle BI, Cognos, MicroStrategy, Business Objects, etc.).Supporting the creation written documentation to accompany all software systems designed to give new users a guide on how to operate themHands-on experience Qlik development, dashboarding, and data modeling techniquesData integration through extracting, transforming, and loading (ETL) from many sourcesData transformation, the creation of QVD files, and set analysisMust be efficient in front-end development and know visualization best practicesEvaluate and analyze business needs and requirements to design solution alternativesAnalyze systems and data sources to determine how to fulfill needs and requirements with available dataCreate data models to efficiently meet reporting and visualization requirements and business needsDesign, construct and integrate Qlik and other data visualization solutionsConduct and support data validation, testing, and peer reviewSupport the implementation of solutions through the development of technical and user documentation, facilitating and leading user trainings, and delivery of ad-hoc user supportLeverage project management software to manage project delivery, requirements, enhancements, and bugsCreate and contribute to the documentation of business processes, practices, and standards for planning, development, and implementation of solutionsFamiliar with agile development methodologyEducation & Experience:7+ years of experience Bachelor's degree in Computer Science, MIS, or related qualificationExperience implementing ETL/ELT data pipelines using custom (JavaScript, Python, PL/SQL, T-SQL, etc.) and packaged tools (e.g. Qlik Replicate, Informatica, DataStage, Talend, Pentaho, StreamSets, Matillion, FiveTran, etc.)Strong skills in databases, data warehouses, data modeling, and data processingExperience with DevOps, Agile methodologies, and CICD methods and toolsExperience with Qlik Mashups, APIs, and third-party Qlik extensions, including VizlibExperience with Qlik GeoAnaltyicsExperience with Web technologiesContact: [email protected] job and many more are available through The Judge Group. Find us on the web at www.judge.com

Career Area: Business Technologies, Digital and Data Job Description: Your Work Shapes the World at Caterpillar Inc. When you join Caterpillar, you're joining a global team who cares not just about the work we do - but also about each other. We are the makers, problem solvers, and future world builders who are creating stronger, more sustainable communities. We don't just talk about progress and innovation here - we make it happen, with our customers, where we work and live. Together, we are building a better world, so we can all enjoy living in it. Cat Digital is the digital and technology arm of Caterpillar Inc., leveraging the latest technologies to build industry leading digital solutions for our customers and dealers. With over 1.5 million connected assets worldwide, our teams use data, technology, advanced analytics, telematics, and AI capabilities to help our customers build a better, more sustainable world. Job Summary: We are seeking a confident, proactive, Senior Backend .Net Developer who can prioritize their work and has good communication skills, to be the Senior Developer responsible for integrating Cat Wear features into our Cat Inspect application. They must be able to dig into an existing application (CWMS) and, with support from the architect, quickly understand the code base and how the product works. The project you will be working on is the creation of a new Cat Inspect product from the merger of Cat Inspect, Cat Wear (CWMS), and Cat Used applications. Working closely with the technical architects, you will be expected to become the technical expert on migrating and rewriting services from Cat Wear (CWMS) and their integration into the new product architecture. This product is strategically important to Cat Digital and will support sales of over $1B per year. What You Do: The technology stack for the existing product includes services written in C# utilizing .Net Framework and hosted in AWS , with services communicating via Elastic Beanstalk. The technology stack for the new product will include services written in C# utilizing .Net 8 , hosted in Azure , with services communicating via Service Fabric and using NoSQL database technology. You will be responsible for: Designing, modifying, developing, writing and implementing backend .Net software programming applications for target system using agile methodology, based on Scrum but closer to a 'Srumban' approach. Acquiring client requirements; resolving workflow problems through automation optimization. Contributing to the backlog refinement and creation of user stories. Writing source code for new applications, and/or generating and enhancing code samples from existing applications. Utilizing automated testing tools to perform testing and maintenance. Providing technical guidance and mentorship to more junior engineers in the team. What You Will Have: Software Development: Extensive knowledge in .Net and C# to perform backend software development by adopting industry's best architecture patterns, security best practices; ability to produce software products or systems in line with product requirements. Software Development Life Cycle: Extensive knowledge of software development life cycle; ability to use a structured methodology (experience in agile methodology preferred) for managing and delivering new or enhanced software products to the marketplace Software Integration Engineering : Working knowledge of software integration processes and functions; ability to design, develop and maintain interfaces and linkage to external platforms and software packages. Software Product Design/Architecture: Extensive knowledge of software product architecture and design; ability to convert market requirements into the software product design. Considerations for Top Candidates: Highly advanced experience developing distributed , service oriented products (typically 5+ years). Extensive experience developing applications deployed and hosted in the Cloud (preferably Cloud Native applications) (typically 5+ years). In depth experience developing applications using C# (typically 3-5+ years). Extensive experience developing applications in .Net ( .Net 8 is ideal, but any .Net6+ and exposure to .Net Framework) (typically 3-5+ years). Proficient experience developing applications hosted on Azure or AWS (preferably Azure) (typically 3-5+ years). Working experience with relational databases (typically 3-5+ years). Experience with NoSQL databases (typically 2+ years). Agile development methodologies, preferably Scrum. Bonus Points: Experience with Service Fabric. ETL experience and/or experience with data migration between two applications. Experience with Apigee. Familiarity with Cat Wear (CWMS), Cat Inspect, or other Cat inspection applications. Attitude, communication and overall capability is more important than specific skills and experience, so an exact match to the technical experience listed is not required, however as this is a Senior Software Engineer position, the successful candidate must have good experience with at least some of the technology stack and be capable of writing and maintaining well designed, high quality, testable code from requirements. What You Will Get: Working with a Fortune 100 leader, you can build your career on a global scale and take advantage of development opportunities with emerging technologies. We've created an inclusive environment for you to explore your passions, make an impact and do the work that really matters. Join Us. Additional Details: This position has the option to be based out of either our Chicago, IL or Peoria, IL offices with a flexible hybrid office environment. #LI-Hybrid #BI (used to post on Built In Chicago) About Caterpillar Caterpillar Inc. is the world's leading manufacturer of construction and mining equipment, off-highway diesel and natural gas engines, industrial gas turbines and diesel-electric locomotives. For nearly 100 years, we've been helping customers build a better, more sustainable world and are committed and contributing to a reduced-carbon future. Our innovative products and services, backed by our global dealer network, provide exceptional value that helps customers succeed. Visa Sponsorship is not available for this position. This employer is not currently hiring foreign national applicants that require or will require sponsorship tied to a specific employer, such as, H, L, TN, F, J, E, O. As a global company, Caterpillar offers many job opportunities outside of the U.S which can be found through our employment website at www.caterpillar.com/careers. Posting Dates: May 3, 2024 - May 19, 2024 Any offer of employment is conditioned upon the successful completion of a drug screen. EEO/AA Employer. All qualified individuals - Including minorities, females, veterans and individuals with disabilities - are encouraged to apply. Not ready to apply? Join our Talent Community .

DepartmentBSD CRI - Data WarehouseAbout the DepartmentThe Center for Research Informatics (CRI) is an organization within the Biological Sciences Division (BSD) that provides informatics resources and services to University faculty in alignment with the mission, vision, and values of the academic medical center. Four main services comprise the CRI's operations: application development, bioinformatics, research storage and computing, and clinical research data warehousing and business intelligence. Through these service lines, the CRI enables clinical and translational research of the highest scientific merit and advances the state of the art of clinical research informatics. The CRI recruits intellectually curious candidates looking to deliver innovative and exciting solutions to biomedical researchers.We are committed to increasing diversity, equity, and inclusion for the benefit of our team members, our institution, our clients, and our community. We will accomplish this by incorporating our values into hiring practices, retention, and culture.Job SummaryThe incumbent will be responsible for completing data requests from the Clinical Research Data Warehouse (CRDW). This includes understanding data extractions, transformations, and loads, writing SQL code to incorporate new data sources into data warehouses and affiliated data marts, both local and distributed, and working with existing teams to further development according to existing standards and conventions. There is also a need for data management expertise. This includes data source acquisition and positioning, providing ongoing feedback and support to expand available data sources while improving the team's understanding of existing data sources, transforming and loading data into data models and platforms, both standardized and unstandardized, and creating and maintaining a growing body of documentation. Finally, this position involves translating technical specifications into SQL code, generating data deliverables, and conducting code reviews. An ideal candidate will be able to quickly master medical terminology related to filling data requests, communicate effectively with business analysts, cross-functional technical teams, and academic clients, and write SQL queries that optimize the organization of data deliverables, perform analyses using R and Python, and generate visualizations using Tableau. Prior to delivery of data, the incumbent will assist with data quality checks, making sure that each deliverable matches the original request specifications, and that the data is of the highest quality. Incumbent must adhere to all institutional data governance policies and may be partially or wholly supported by partnerships with Departments, Sections, and other Research Units. Positions with contractual grant funding or other departmental funding support may be required to work in person up to 4 days per week. Position operates within a federal recharge center.This at-will position is wholly or partially funded by contractual grant funding which is renewed under provisions set by the grantor of the contract. Employment will be contingent upon the continued receipt of these grant funds and satisfactory job performance.ResponsibilitiesGather and analyze healthcare and other related data to identify and interpret trends in support of data requests, business cases, and proposed projects.Design, construct, test, and maintain data warehouse and related functionality including extraction and transformation of data using SSIS.Design, develop, and test business intelligence outputs (including visualization) to ensure useful and insightful information using software including R, Tableau, and/or Excel to support research and quality improvement initiatives.Test and validate data with the purpose of understanding and making conclusions to support decision-making processes.Manage a variety of information systems and data files, including large and complex files: analyzing file structure, using and creating file layouts, transforming raw data into finished products.Monitor for timely and accurate completion of work.Participate in strategic initiatives to enhance data management and reporting to support research and quality improvement initiatives.Collaborate closely with a cross-functional team of Data Scientists, Project Managers, and Developers to ensure high-quality data delivery to faculty.Collaborate with faculty, staff, and other research teams.Perform duties in a matrixed management environment.Proactively identify issues and opportunities to improve data systems and related policies as an aspect of data governance.Communicate effectively with management, support staff, and faculty partners.Adhere to all institutional data governance policies.Develops Business Intelligence (BI) and other analytical applications. Works to achieve an integrated reporting and analysis environment, effectively leveraging analytical systems and tools.Guides requirements analysis, translating requirements into a scope document and developing reporting deliverables based on the design.Works with users to ensure deliverables are meeting or exceeding expectations. Provides support and communicates issues to users as defined by IT standards.Performs other related work as needed.Minimum QualificationsEducation:Minimum requirements include a college or university degree in related field.---Work Experience:Minimum requirements include knowledge and skills developed through 5-7 years of work experience in a related job discipline.---Certifications:---Preferred QualificationsEducation:Healthcare or clinical/medical degree.Experience:5 years of experience with ETL tools.5 years of experience with SQL, Python, Java, Tableau.Experience translating between clinical and IT/informatics domains.Experience with various common data models (OMOP, PCORnet).Licenses and Certifications:Clarity certification.Preferred CompetenciesUnderstanding of various common data models (OMOP, PCORnet).Understanding of research methodology and healthcare terminology.High level of problem-solving and decision-making skills.Knowledge of healthcare data including ICD-9, ICD-10, and CPT.Expert in SQL and Excel.Proficiency in relational databases with experience designing transformations, mappings, and working with reference tables.Ability to translate technical information to non-technical audiences.Critical thinking and multi-tasking skills with the ability to manage multiple projects.Time management skills.Proficiency in creating technical specifications, business cases, and other development-related documentation.Experience in other analytic platforms including R, Stata, Python, SAS.Experience with business intelligence and visualization tools such as Tableau, Power BI, etc.Experience investigating data issues and working with a cross-functional team for problem resolution.Strict understanding of and adherence to data governance policies.Working ConditionsOffice, hybrid.Positions that share funding with departments, sections, or other research units may be required to be on campus up to 4 days per week.Application DocumentsResume (required)Cover Letter (preferred)When applying, the document(s) MUSTbe uploaded via the My Experience page, in the section titled Application Documents of the application.Job FamilyInformation TechnologyRole ImpactIndividual ContributorFLSA StatusExemptPay FrequencyMonthlyScheduled Weekly Hours40Benefits EligibleYesDrug Test RequiredNoHealth Screen RequiredNoMotor Vehicle Record Inquiry RequiredNoPosting StatementThe University of Chicago is an Affirmative Action/Equal Opportunity/Disabled/Veterans and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender, gender identity, national or ethnic origin, age, status as an individual with a disability, military or veteran status, genetic information, or other protected classes under the law. For additional information please see the University's Notice of Nondiscrimination.Staff Job seekers in need of a reasonable accommodation to complete the application process should call 773-702-5800 or submit a request via Applicant Inquiry Form.We seek a diverse pool of applicants who wish to join an academic community that places the highest value on rigorous inquiry and encourages a diversity of perspectives, experiences, groups of individuals, and ideas to inform and stimulate intellectual challenge, engagement, and exchange.All offers of employment are contingent upon a background check that includes a review of conviction history. A conviction does not automatically preclude University employment. Rather, the University considers conviction information on a case-by-case basis and assesses the nature of the offense, the circumstances surrounding it, the proximity in time of the conviction, and its relevance to the position.The University of Chicago's Annual Security & Fire Safety Report (Report) provides information about University offices and programs that provide safety support, crime and fire statistics, emergency response and communications plans, and other policies and information. The Report can be accessed online at:http://securityreport.uchicago.edu.Paper copies of the Report are available, upon request, from the University of Chicago Police Department, 850 E. 61st Street, Chicago, IL 60637.