logo

View all jobs

BI / Database Developer I

Overland Park, KS · Information Technology
TITLE: Jr. BI/Database Developer I (2100V5)
LOCATION: 10990 Roe Ave, Overland Park, KS 66211 or USA
COVID STATUS:  100% Remote or Onsite
TYPE:  Perm
ONBOARDING PROCESS: Immediate
COMPENSATION: Commensurate with Experience – Targeting 75-85K
YEARS OF EXP: 1-3 Yrs.
AREAS OF EXPERTISE: MS SQL Server, SSIS, SSAS, SSRS, T-SQL, Stored Procedures, Views, Triggers, MS PowerBI, ETL, Batch Processing, PowerShell Automation Scripting
INTERVIEW PROCESS:
• Initial interview will be w/ Hiring Manager - video call
• Interview w/ 1-2 technical resources
 
JOB SUMMARY 
  • Under limited supervision, the qualified candidate will be responsible for review, design, analysis, new development, and modification of current reporting systems.
  • He/she will also be responsible for the optimization and performance improvements of the new code base.
  • Responsibility will include design and development of the batch and near-real time data integration processes, Business Intelligence (BI) solutions, development in heterogeneous databases environment.
ESSENTIAL DUTIES AND RESPONSIBILITIES
  1. Ensure accuracy and integrity of the data and applications through analysis, coding, writing clear documentation and problem resolution.
  2. Analyze data structures content and ensure performance validity.
  3. Design, code, test, and implement reports using modern tools and techniques (Power BI, Business Objects, etc.)
  4. Design, code, test, and implements BI solutions, including report, dashboards, notifications, in support of the business requirements.
  5. Participate in research and apply innovation at all levels of the report/dashboard development process.
  6. Work on multiple projects simultaneously and manage competing priorities.
  7. Work harmoniously in a cross-functional teams including IT and business resources.
  8. Function as technical lead and Subject Matter Expert (SME) on assigned projects.
  9. Provide excellent customer service by responding to and assisting with resolving issues and system outages.
COMPETENCIES 
  1. Adaptability - Maintaining effectiveness when experiencing major changes in work responsibilities or environment (e.g., people, processes, structure, or culture); adjusting effectively to change by exploring the benefits, trying new approaches, and collaborating with others to make the change successful. 
  2. Building Trusting Relationships - Using appropriate interpersonal styles to establish effective relationships with customers and internal partners; interacting with others in a way that promotes openness and trust and gives them confidence in one’s intentions. 
  3. Collaborating - Working cooperatively with others to help a team or work group achieve its goals. 
  4. Communication - Conveying information and ideas clearly and concisely to individuals or groups in an engaging manner that help them understand and retain the message; listening actively to others.
  5. Continuous Learning - Actively identifying new areas for learning; regularly creating and taking advantage of learning opportunities; using newly gained knowledge and skill on the job and learning through their application. 
  6. Initiating Action - Taking prompt action to accomplish work goals; taking action to achieve results beyond what is required; being proactive. 
  7. Work Standards - Setting high standards of performance for self and others; assuming responsibility and accountability for successfully completing assignments or tasks; self-imposing standards of excellence rather than having standards imposed. 
MINIMUM REQUIREMENTS
  1. Bachelor’s Degree preferably in Computer Science, Mathematics or related field.
  2. Experience with Transact-SQL, SSIS, SSRS, Stored Procedures, Views, etc.
  3. Experience specializing in transforming XML, Flat files, or other delimited formats into RDBMS.
  4. MS SQL Server experience is required.
  5. Sound knowledge of traditional as well as agile software development methodologies
  6. Experience with SSAS (Tabular and Multidimensional) and MS Power BI.
  7. Strong ability to carry out research and innovation.
  8. Experience with Batch Jobs, Scheduling, SQL Agent, and PowerShell.
  9. Sound knowledge and experience working with software application, database design, and BI ideas.
  10. Highly effective working in a team, as well as working independently.
  11. Experience working in a reporting development environment.
  12. Good oral and written communication skills
  13. Strong initiative and organization skills
  14. Strong customer service and interpersonal skills
PREFERRED QUALIFICATIONS
  1. Skilled in communicating effectively verbally and in writing.
  2. Ability to establish and maintain effective working relationships.
  3. Proficient with Microsoft Office products, including Word, Excel, PowerPoint, and Outlook.
  4. Automated scripting experience with tools like PowerShell,
BENEFITS
  • Competitive pay based on experience
  • Employee selected medical, dental, and vision coverage for you and your family
  • PTO and paid holidays
  • 401k Retirement Plan
 
Covenant Consulting strives to attract, cultivate and retain exceptional talent. If you feel you are a match for the position, and are interested in a great growth opportunity, we encourage you to contact Shannon.McInnis@Covenant-Consulting.com

Covenant Consulting is a Technology Services Provider offering project-based IT consulting, IT staffing and IT recruiting services. Every partnership reflects our uncompromising commitment to quality and integrity. We have extensive experience and capabilities in project-based consulting, short and long-term staff augmentation, and permanent recruitment. We work with companies of every size, across many industries and have the flexibility to scale solutions to meet our client's specific needs. 

 
Shannon McInnis
Sr. Technical Recruiter
shannon.mcinnis@covenant-consulting.com
713-705-1880
Powered by