SQL Report Developer

<p>With more than 7,000 employees, we are the largest health insurance company in Michigan. We offer an exciting work environment with a diverse group of employees. Our goal is to make health insurance easier for our members. We want to transform the industry and become a resource that people can trust.<br /><br /><br /><br /><br /><br /></p>

Detroit, MI

Blue Cross Blue Shield of Michigan

When you think of <a href="https://www.bcbsm.com/" target="_blank" rel="noopener noreferrer">Blue Cross Blue Shield of Michigan</a> for health insurance, you can know you&rsquo;re getting much more. We're a company founded on a tradition of affordable, quality health care for everyone, improving the present and investing in the future.<br /><br />We offer:<br />Plans for employers and individuals that meet today&rsquo;s needs, budgets and lifestyle<br />The largest network of doctors and hospitals in the state<br />Lower health care costs Higher quality health care<br />Award-winning diversity practices<br />Grants and programs that promote better health throughout Michigan<br /><strong><br />Mission:&nbsp;</strong>We commit to being our members&rsquo; trusted partner by providing affordable, innovative products that improve their care and health.<br /><br /><a href="http://www.bcbsm.com/index/about-us/our-company.html" target="_blank" rel="noopener noreferrer"><strong>Click here</strong></a> to learn more about our commitment to our Social Mission, view company updates and reviews, and view our awards &amp; accolades.<br /><br />Learn more about your options as an external candidate. <a href="https://bcbsm.taleo.net/careersection/2/jobsearch.ftl?lang=en" target="_blank" rel="noopener noreferrer">Click here</a> to view open positions.&nbsp; http://www.bcbsm.com

keywords: professional,analysis,technical,teamwork,quality assurance,organization,training,experience,degree,knowledge

Full-time

Competitive Total Compensation Package

Overview: <p>The Systems Analyst will primarily be responsible for developing / enhancing complex T-SQL views and stored procedures for reporting and ETL processing.&nbsp; A solid understanding of database design practices will be expected and leveraged to update existing star schemas.&nbsp; Candidate will utilize SSAS for OLAP development.&nbsp; Power BI hosted from SharePoint Online will connect to an on-premise OLAP cube for dashboards and analytics.&nbsp; To be successful in this role, a person will be able to build trusting relationships with business partners, understand their processes, translate wants to needs, and collaborate on solutions.</p> <p style="font-weight: 400;">Position will also require testing, demos to customers, and implementation of changes during the life cycle of the request.&nbsp; Attention to detail with the highest levels of quality is critical as the customer audience will range from analysts to executives.</p> <p style="font-weight: 400;"><strong>Plan, develop, test and implement IT system solutions that improve business efficiency and productivity as well as support business strategies and goals.&nbsp; Identify and communicate business needs and translate business requirements into technical system and functional specifications.&nbsp; Support one or more moderately to highly complex business processes/systems for multiple business units.&nbsp; Project team member for projects medium to large in scope and high complexity.</strong></p>
Responsibilities: <ul> <li>Participate in business short-term planning sessions to ensure understanding of business goals, direction and business requirements; provide input from an IT systems perspective. Participate in the estimation of costs for the planning of new systems/enhancements for assigned systems. Serve as a liaison between business area and the IT organization and vendors in coordination with project managers to provide technical solutions that address user needs.</li> <li>Translate business requirements into technical requirements.&nbsp; Formulate and define system scope and objective based on user needs and understanding of business processes.&nbsp; Develop, write, and communicate systems design, functional system specifications and functional architecture analysis. Identify gaps or issues.</li> <li>Analyze customer&rsquo;s systems and capabilities to understand strengths and weaknesses for the identification of opportunities for system improvement.</li> <li>Develop user and/or system test cases and validate test results during testing, as needed. Document system modifications.&nbsp; Develop system manuals, system training materials and system enhancement communication.</li> <li>Identify, investigate, resolve and escalate problems, as needed.&nbsp; Gather data to support recommendations to address problems.&nbsp; Procure technical assistance to help in problem resolution.</li> <li>Work closely with developers and end users to ensure technical compatibility and user satisfaction.</li> <li>Provide factual content to feasibility study for standard development projects and enhancements. Stay abreast of new and emerging technologies.&nbsp; Analyze technology trends to determine impact to the achievement of business goals.&nbsp; Identify issues based on impact of new/emerging technology or modifications to existing systems.</li> <li>Provide input for the development of Service Level Agreements (SLAs) and/or forecasting activities as needed.&nbsp; Review performance against SLAs. Identify areas for improvement.&nbsp; Support achievement of SLAs.</li> <li>Coach and mentor less experienced team members.</li> <li>Other duties as assigned.</li> </ul>
Requirements: <p><strong>EDUCATION AND/OR EXPERIENCE</strong></p> <ul> <li>Bachelor's degree in related field preferred.</li> <li>Three (3) years of relevant system solution development, testing and implementation work experience required.</li> </ul> <p><strong><u>Job Requirements</u></strong></p> <p><strong>Qualifications</strong></p> <ul> <li>Minimum 3-5 years related experience.</li> <li>3-5 years writing medium to high complexity T-SQL queries or equivalent</li> <li>3-5 years using SQL Server Analysis Services (SSAS)</li> <li>1-3 years with Power BI</li> <li>3-5 years using SQL Server Reporting Services (SSRS)</li> <li>High attention to detail</li> <li>Ability to work independently on multiple assignments with minimal supervision&nbsp;</li> </ul> <p><strong>Preferences</strong></p> <ul> <li>Database design</li> <li>Crystal Reports</li> <li>1-2 years general programming experience</li> </ul> <p><strong>OTHER SKILLS AND ABILITIES</strong></p> <ul> <li>Strong analytical, technical, interpersonal and communication skills.</li> <li>Knowledge of business operations, systems requirements and IT processes.</li> <li>Ability to work independently, or within a team environment.</li> <li>Other related skills and/or abilities may be required to perform this job.</li> </ul>