Business Intelligence Developer
Job title: Business Intelligence Developer in Chevy Chase, MD at GEICO
Company: GEICO
Job description: This role is responsible for the development of operational data reporting, data engineering, and the development of data sets and data tools including data extracts, reports, and dashboards. This role will be responsible for proactively developing, testing, and maintaining critical data pipelines and architectures across multiple technical environments within various business functions in support of the GEICO’s operational data reporting. As a member of an agile team, the developer assists with testing, validation, user acceptance testing, deployment, and post-implementation support. This includes writing code that builds datasets, metrics, and data needed for our business partners.Responsibilities:Create SQL stored procedures, advanced queries, debugging, and optimization.Rewrite SAS code into SSIS Packages and Power BI, including SSIS debugging.Design, update, and maintain relational databases.Develop process automation and ETL solutions.Maintain and support daily data refresh proceduresPerform and automate daily maintenance processes.Creates and prepare data sets for reporting and dashboardDebug, troubleshoot, and optimize new and existing processes.Assist with data and database migrations, testing, and validation.Create MS SQL Server procedures and batch jobs to extract, transform and load dataDevelop and test reports and data extractsAdhere to development standards and software change management proceduresAssist with proposing new data strategies and methods to enhance and advance the data environmentAssist with project and time management, including estimates and status reporting.Conduct root cause analysis and advanced performance tuning functionsDesign and implement data models and database architectures to support client projects and initiativesWork closely with cross-functional teams to ensure the successful delivery of data engineering solutionsQualifications:5+ years of relevant work experience (SQL developer and data visualization)Proficient in Power BI, SQL, SAS, and SSISStakeholder management skillsStrong quantitative, analytical, problem solving, organizational, communication and interpersonal skills are requiredAbility to provide technical guidance and mentorship to junior team members as neededMust be able to work both independently and in a team environmentMust be able to multi-taskMust be able to learn and apply large amounts of technical and procedural informationMust be able to communicate effectively verbally and in writingLocation: In office Hybrid work requirement: In office 3 days per week (required)Annual Salary $68,000.00 - $138,000.00The above annual salary range is a general guideline. Multiple factors are taken into consideration to arrive at the final hourly rate/ annual salary to be offered to the selected candidate. Factors include, but are not limited to, the scope and responsibilities of the role, the selected candidate’s work experience, education and training, the work location as well as market and business considerations.At this time, GEICO will not sponsor a new applicant for employment authorization for this position.The GEICO Pledge:Great Company: At GEICO, we help our customers through life’s twists and turns. Our mission is to protect people when they need it most and we’re constantly evolving to stay ahead of their needs.We’re an iconic brand that thrives on innovation, exceeding our customers’ expectations and enabling our collective success. From day one, you’ll take on exciting challenges that help you grow and collaborate with dynamic teams who want to make a positive impact on people’s lives.Great Careers: We offer a career where you can learn, grow, and thrive through personalized development programs, created with your career – and your potential – in mind. You’ll have access to industry leading training, certification assistance, career mentorship and coaching with supportive leaders at all levels.Great Culture: We foster an inclusive culture of shared success, rooted in integrity, a bias for action and a winning mindset. Grounded by our core values, we have an an established culture of caring, inclusion, and belonging, that values different perspectives. Our teams are led by dynamic, multi-faceted teams led by supportive leaders, driven by performance excellence and unified under a shared purpose.As part of our culture, we also offer employee engagement and recognition programs that reward the positive impact our work makes on the lives of our customers.Great Rewards: We offer compensation and benefits built to enhance your physical well-being, mental and emotional health and financial future.
Expected salary: $68000 - 138000 per year
Location: Chevy Chase, MD
Apply for the job now! [ad_2] Apply for this job
Company: GEICO
Job description: This role is responsible for the development of operational data reporting, data engineering, and the development of data sets and data tools including data extracts, reports, and dashboards. This role will be responsible for proactively developing, testing, and maintaining critical data pipelines and architectures across multiple technical environments within various business functions in support of the GEICO’s operational data reporting. As a member of an agile team, the developer assists with testing, validation, user acceptance testing, deployment, and post-implementation support. This includes writing code that builds datasets, metrics, and data needed for our business partners.Responsibilities:Create SQL stored procedures, advanced queries, debugging, and optimization.Rewrite SAS code into SSIS Packages and Power BI, including SSIS debugging.Design, update, and maintain relational databases.Develop process automation and ETL solutions.Maintain and support daily data refresh proceduresPerform and automate daily maintenance processes.Creates and prepare data sets for reporting and dashboardDebug, troubleshoot, and optimize new and existing processes.Assist with data and database migrations, testing, and validation.Create MS SQL Server procedures and batch jobs to extract, transform and load dataDevelop and test reports and data extractsAdhere to development standards and software change management proceduresAssist with proposing new data strategies and methods to enhance and advance the data environmentAssist with project and time management, including estimates and status reporting.Conduct root cause analysis and advanced performance tuning functionsDesign and implement data models and database architectures to support client projects and initiativesWork closely with cross-functional teams to ensure the successful delivery of data engineering solutionsQualifications:5+ years of relevant work experience (SQL developer and data visualization)Proficient in Power BI, SQL, SAS, and SSISStakeholder management skillsStrong quantitative, analytical, problem solving, organizational, communication and interpersonal skills are requiredAbility to provide technical guidance and mentorship to junior team members as neededMust be able to work both independently and in a team environmentMust be able to multi-taskMust be able to learn and apply large amounts of technical and procedural informationMust be able to communicate effectively verbally and in writingLocation: In office Hybrid work requirement: In office 3 days per week (required)Annual Salary $68,000.00 - $138,000.00The above annual salary range is a general guideline. Multiple factors are taken into consideration to arrive at the final hourly rate/ annual salary to be offered to the selected candidate. Factors include, but are not limited to, the scope and responsibilities of the role, the selected candidate’s work experience, education and training, the work location as well as market and business considerations.At this time, GEICO will not sponsor a new applicant for employment authorization for this position.The GEICO Pledge:Great Company: At GEICO, we help our customers through life’s twists and turns. Our mission is to protect people when they need it most and we’re constantly evolving to stay ahead of their needs.We’re an iconic brand that thrives on innovation, exceeding our customers’ expectations and enabling our collective success. From day one, you’ll take on exciting challenges that help you grow and collaborate with dynamic teams who want to make a positive impact on people’s lives.Great Careers: We offer a career where you can learn, grow, and thrive through personalized development programs, created with your career – and your potential – in mind. You’ll have access to industry leading training, certification assistance, career mentorship and coaching with supportive leaders at all levels.Great Culture: We foster an inclusive culture of shared success, rooted in integrity, a bias for action and a winning mindset. Grounded by our core values, we have an an established culture of caring, inclusion, and belonging, that values different perspectives. Our teams are led by dynamic, multi-faceted teams led by supportive leaders, driven by performance excellence and unified under a shared purpose.As part of our culture, we also offer employee engagement and recognition programs that reward the positive impact our work makes on the lives of our customers.Great Rewards: We offer compensation and benefits built to enhance your physical well-being, mental and emotional health and financial future.
- Comprehensive Total Rewards program that offers personalized coverage tailor-made for you and your family’s overall well-being.
- Financial benefits including market-competitive compensation; a 401K savings plan vested from day one that offers a 6% match; performance and recognition-based incentives; and tuition assistance.
- Access to additional benefits like mental healthcare as well as fertility and adoption assistance.
- In office and remote opportunities, as well as our signature GEICO Flex program, offering the ability to work remotely for up to four weeks per year.
Expected salary: $68000 - 138000 per year
Location: Chevy Chase, MD
Apply for the job now! [ad_2] Apply for this job