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.</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. http://www.bcbsm.com

keywords: database,process management,build,quality assurance,organization,analysis,analysis,technical,teamwork,support,management,solutions,quality assurance,organization,document,training,write,experience,professional,organization,degree,analysis,knowledge,department preferences


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;">&nbsp;</p>
Responsibilities: <p>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.</p> <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.&nbsp;</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>JOB REQUIREMENTS</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>&nbsp;Ability to work independently on multiple assignments with minimal supervision</li> </ul> <p>DEPARTMENTAL PREFERENCES</p> <ul> <li>Advanced skills in creating executive level presentations using Microsoft Power Point</li> <li>Advanced skills in performing data analysis, pivot tables and data queries using Microsoft Excel</li> <li>Knowledge and experience creating reports and dashboard using Microsoft Power Pivot and Power BI</li> <li>Strong statistical and predictive analytical skills with focus on identifying trends and outliers</li> <li>Database design</li> <li>Crystal Reports</li> <li>1-2 years general programming experience</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> <p><em>All qualified applicants will receive consideration for employment without regard to, among other grounds, race, color, religion, sex, national origin, sexual orientation, age, gender identity, protected veteran status or status as an individual with a disability.</em></p>