C1: 1 Contact, 1 Connection, 1 Choice

C1 is the foremost, single-source provider of advanced communications and data technology for business. That means if it's digital, we connect our customers to it -- from phone systems and hardware to computer networks, application development, managed solutions and more. And we're 100% passionate with designing, implementing, managing and supporting our customers' every need from end to end, so that they can focus on what they do best.

So, when it comes to joining a team of IT and communications technology pros who are empowered to do what they do best, your best choice -- your #1 choice -- is C1.

The Reporting and Analytics Developer role is responsible to build design, develop, and maintain reports and queries for a multi-tier, high-end business application. This position will work with customers and internal subject matter experts to design reporting specifications. This position will be responsible for data consolidation, data analysis and management reporting. This role is key in leading initiatives providing reporting and visualization into system and level clinical and financial performance. Creates reports based on requirements submitted by various departments within Fairview. Identify issues and opportunities to enhance data management and reporting, and is responsible for both detailed and high-level problem solving, data analysis, data extraction and reporting. They would be working closely with the Lead DBA , Product Owner and Security Officer  in developing solutions in SSRS, BI tools ( QlikView, QlikSense, PowerBI ), as well as creating and maintaining audit reports.

• Bachelors in Business MIS, or Computer Science (or equivalent work experience)
• 4+ years’ experience in database administration of development
• 4+ years’ experience in technology or finance fields  
• Certifications in SQL or other database technology
• Strong understanding of database structures, theories, principles, and practices
• Working technical experience with designing, building, installing, configuring and supporting database servers, including SQL and other Microsoft products
• Experience with MS Dynamics CRM, GP, etc.
• Hands-on database tuning and troubleshooting experience
• Experience with data processing flowcharting techniques
• Good understanding of the organization’s goals and objectives
• Knowledge of applicable data privacy practices and laws
• Good written and oral communication skills
• Strong technical documentation skills
• Good interpersonal skills
• Ability to conduct research into database issues, standards and products as required
• Ability to present ideas in user-friendly language
• Highly self-motivated and directed
• Keen attention to detail
• Proven analytical and problem-solving abilities
• Ability to effectively prioritize and execute tasks in a high-pressure environment
• Strong customer service orientation
• Experience working in a team-oriented, collaborative environment

• Participates in initiatives to various types reporting and analytic output through SQL Server tools as requested to support the business; SSRS report development and/or SQL coding are foundational technologies critical to successful information delivery. Role will include the use of advanced analytic and visualization tools and methods
• Conducts Performance Tuning and Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
• Demonstrates a strong knowledge of how indexes, index management, integrity checks, configuration, patching
• Demonstrates knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
• Writes and troubleshoots SQL Code ( stored procs, functions, tables, views, triggers, indexes, constraints )
• Evaluates new data sources for adherence to the organization's quality standards and ease of integration
• Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions
• Provides database support by coding utilities, responding to user questions, and resolving problems
• Updates job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations
• Accomplishes information systems and organization mission by completing related results as needed
• Creates functions to provide custom functionality as per the requirements
• Develops best practices around database reporting and Business Intelligence tools

C1 BENEFITS

* 401(k) Plan (35% employer match per dollar up to 10% employee contribution)
* Medical Coverage (3 platforms: UnitedHealthcare, Reference Based Pricing includes comprehensive member advocacy; and Kaiser)
* HSA with + Employer Contribution
* In-vitro Fertility (treatment coverage)
* Dental
* Vision (2 plans: 12-month and 24-month frames allowance)
* FSA Plans (Healthcare, Dependent care and Limited Purpose)
* Pre-tax Commuter Plans
* Employer-paid Life Insurance
* Employer-paid Short + Term Disability
* Long Term Disability (2 plans: Employer-paid and Self-paid with non-taxable claim payments)

* Paid Parental Leave (4 weeks at 100%)
* Employee Assistance Plan
* Voluntary Life Insurance
* Legal/ID Theft Plans
* TeleHealth Options
* Wellness via Omada Health (healthy living solution)
* Travel Assistance
* Business Travel Accident Coverage
* Employer-paid Pet Telehealth
* Accident Insurance
* Critical Illness Insurance
* Hospital Indemnity Insurance
* Volunteer Time Off

* On Demand Pay (Daily Pay)

Work Environment
Ability to handle multiple priorities and demands in a fast-paced environment. This job operates in a professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, and filing cabinets.

Physical Environment
Physical demands described here are representative of those that must be met by a team member to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this job.

Other Duties/Changes
This job description is not designed to cover or contain a comprehensive listing of all duties, responsibilities or activities that are required of a team member for this job. Duties, responsibilities and activities may change at any time with or without notice. At any point in time, the essential functions and primary duties associated with this position will be the principal, major or most important duties, responsibilities and activities that the employee is expected to perform as determined and directed by C1.

EEO Statement
C1 provides equal employment opportunities (EEO) to all team members and applicants for employment opportunities. All qualified applicants will receive consideration for employment, and all team members will be treated with respect to their employment, without regard to race, color, religion, gender, national origin, age, sexual orientation, gender identity, disability or veteran status. For further details please view the Equal Employment Opportunity Posters provided by OFCCP. http://www.dol.gov/ofccp/regs/compliance/posters/ofccpost.htm<http://www.dol.gov/ofccp/regs/compliance/posters/ofccpost.htm>

Notice of E-Verify Participation

https://e-verify.uscis.gov/web/media/resourcesContents/E-Verify_Participation_Poster_ES.pdf <https://e-verify.uscis.gov/web/media/resourcesContents/E-Verify_Participation_Poster_ES.pdf>

Right to Work

https://www.e-verify.gov/sites/default/files/everify/posters/IER_RightToWorkPoster%20Eng_Es.pdf<https://www.e-verify.gov/sites/default/files/everify/posters/IER_RightToWorkPoster%20Eng_Es.pdf>