SQL Server Analysis jobs near me - 6 jobs

Job Title: Computer Programmer Role: Information Technology Industry: I.T. Job Type: Permanent full-time Job description: Primarily responsible for database programming. General Purpose: Computer programming, system support; Client relations; problem resolution; critical thinking; database maintenance; relationship building Essential Duties and Responsibilities: * Design and develop SQL stored procedures to automate workflows and/or optimize application performance * Requirements gathering, database design, business logic development, application integration, software deployment and maintenance of existing systems * Develop SQL procedures/functions * Compile and write documentation of program development and subsequent revisions, inserting comments in the coded instructions so others can understand the program * Conduct trial runs of new program applications to be sure they will produce the desired information and that the instructions are correct * Correct errors by making appropriate changes and then rechecking the program to ensure that the desired results are produced * Consult with manager to clarify program intent, identify problems, and suggest changes * Perform revision, repair, or expansion of existing programs to increase operating efficiency or adapt to new requirements * Perform ad-hoc requests for data manipulations, imports, exports, and updates * Establish and maintain interpersonal relationships by way of developing constructive and cooperative working relationships with others, and maintaining them over time * Attend client, department and company meetings * Comply with federal and state laws, company and department policies and procedures * All other duties as assigned Essential Skills and Experience: * BS in Computer Science, Computer Engineering, Information Technology, Computer Information Systems or other technical discipline and/or related development experience using Microsoft technologies * Experience with SQL Server 2008/2008R2 (including SQL Server Analysis Services; SQL Server Integration Services; SQL Server Reporting Services, TSQL, cursers, triggers, stored procedures, views, etc.) * Experience developing and maintaining databases using the Microsoft Business Intelligence Stack within SQL Server * Experience testing, debugging and documenting systems * Familiarity with general computer use, computing theory and systems analysis methodologies * Experience in .NET web-service frameworks (WCF, SOAP, MVC, Web API, etc.) * Excellent work ethic, dependable and responsible * Strong logical and creative problem-solving skills, good oral and written communication skills and excellent analytical skills * Commitment to company values Nonessential Skills and Experience: * Microsoft Certified in Business Intelligence * Experience of agile software methodologies and test driven development Bottom Line Requirements: 1. BS in Computer Science, Computer Engineering, Information Technology or related preferred. 2. Development experience using Microsoft technologies including SQL Server 2008/2008R2 and C#. 3. Experience developing and maintaining databases using the Microsoft Business Intelligence Stack within SQL Server. 4. Experience in .NET web-service frameworks. Additional Information All your information will be kept confidential according to EEO guidelines.

First Solar reserves the right to offer you a role most applicable to your experience and skillset. Basic Job Functions: Performs advanced level administration activities in the SQL Server database domain. Develop, maintain, and implement policies and procedures and best practices that ensures availability, security and integrity of the First Solar's databases. Implements data models and database designs, data access and table maintenance codes; resolves database performance issues, database capacity issues, replication, and other distributed data issues. Architect solutions for major database initiatives and work with other architects to ensure solutions are reviewed appropriately before implementation. Mentor other team members in the best practices of database administration. Education/Experience: Minimum 7 years of database administration work experience with Microsoft SQL Server. Bachelor's degree in information technology or related field or equivalent years of work experience. Required Skills/Competencies: Minimum 7 years of database administration experience with Microsoft SQL Server. Advanced skills in database performance factors, backup, recovery, monitoring tools and tuning procedures. Advanced experience of MS SQL Server and Windows technology like Database Clustering especially complex SQL Always On clusters, Mirroring, Table Partitioning, Log Shipping, and Data Replication. Advanced skills in SQL Server Upgrades (Cumulative Packs and version upgrades). Different ways of database backup and restore processes. Advanced skills with SQL, query writing and tuning. Advanced skills with debugging stored procedures and triggers. Advanced skills in productivity factors and ability to understand impact of problem on overall database performance. Knowledge of fault detection and resolution processes. Advanced skills in maintenance tools and procedures. Familiarity with PowerShell scripting is a plus. Ability to define physical and logical data structures. Ability to understand the integration and work with the enterprise applications. Experience with SSIS (SQL Server Integration Services). Experience with SSAS (SQL Server Analysis Services). SQL Server Consolidation & Virtualization. Setting up Base lining and Capacity Planning. Configuring Replication / Data Synchronization. SQL Server Database Monitoring - Preventive alerts. Working knowledge and/or prior experience in Cloud Data/Database administration a plus. Familiarity with third party backup software is a plus. Essential Responsibilities: Primary Responsibilities: Lead Major initiatives and mentor other admins. Architect solutions and document policies and procedures for major database initiatives. Physical and logical database design. Recoverability - Creating and testing Backups, optimize existing database backup procedures to ensure integrity, and to improve recoverability. Integrity - Verifying or helping to verify data integrity. Security - Defining and/or implementing access controls to the data, OS and DB level security patching. Availability - Ensuring maximum uptime. Supportability - DB Server Upgrades and cumulative packs to the latest version. Performance - Ensuring maximum performance given budgetary constraints. Development and testing support - Helping programmers and engineers to efficiently utilize the database. Identify offensive SQLs and implement best practices for DBAs and development teams to follow. Working Experience on Windows Mirroring and MS Cluster and Replication. Knowledgeable of ITIL practices and methodologies (i.e. Incident, Problem, and Change Management). Support IT Initiatives, process, and procedures around SOX controls. Must be able to serve Database on-call on a routine basis. Global Player, work in “follow-the-sun” environment. Key Competencies: Conducts security risk and vulnerability assessments for defined business applications or IT installations in defined areas, and provides advice and guidance on the application and operation of elementary physical, procedural and technical security controls (e.g. the key controls defined in ISO27001). Performs risk and vulnerability assessments, and business impact analysis for medium size information systems. Investigates suspected attacks and manages security incidents. Maintains knowledge of specific technical specialists provides detailed advice regarding their application and executes specialized tasks. The specialism can be any area of information or communication technology, technique, method, product or application area. Maintains awareness of opportunities provided by new technology to address challenges or to enable new ways of working. Within own sphere of influence, works to further organizational goals, by the use of emerging technologies and products. Contributes to briefings and presentations about their relevance and potential value to the organization. Undertakes routine installations and de-installations of items of hardware and/or software. Takes action to ensure targets are met within established safety and quality procedures, including, where appropriate, handover to the client. Conducts tests of hardware and/or software using supplied test procedures and diagnostic tools. Corrects malfunctions, calling on other experienced colleagues and external resources if required. Documents details of all hardware/software items that have been installed and removed so that configuration management records can be updated. Develops installation procedures and standards, and schedules installation work. Provides specialist guidance and advice to less experienced colleagues to ensure best use is made of available assets, and to maintain or improve the installation service. Monitors service component capacity and initiates actions to resolve any shortfalls according to agreed procedures. Applies techniques to modify demand for a particular resource or service. Contributes to the availability management process and its operation and performs defined availability management tasks. Analyses service and component availability, reliability, maintainability and serviceability. Ensures that services and components meet and continue to meet all of their agreed performance targets and service levels. Implements arrangements for disaster recovery and documents recovery procedures. Conducts testing of recovery procedures. Performs defined tasks to monitor service delivery against service level agreements and maintains records of relevant information. Analyses service records against agreed service levels regularly to identify actions required to maintain or improve levels of service, and initiates or reports these actions. Assesses, analyses, develops, documents and implements changes based on requests for change. Assesses and analyses release components. Provides input to scheduling. Carries out the builds and tests in coordination with testers and component specialists maintaining and administering the tools and methods - manual or automatic - and ensuring, where possible, information exchange with configuration management. Ensures release processes and procedures are maintained. Reviews system software updates and identifies those that merit action. Tailors' system software to maximize hardware functionality. Installs and tests new versions of system software. Investigates and coordinates the resolution of potential and actual service problems. Prepares and maintains operational documentation for system software. Advises on the correct and effective use of system software. Investigates identified security breaches in accordance with established procedures and recommends any required actions. Assists users in defining their access rights and privileges, and administers logical access controls and security systems. Maintains security records and documentation. Investigates identified security breaches in accordance with established procedures and recommends any required actions. Assists users in defining their access rights and privileges, and administers logical access controls and security systems. Maintains security records and documentation. Maintains application support processes, and checks that all requests for support are dealt with according to agreed procedures. Uses application management software and tools to investigate issues, collect performance statistics and create reports. Ensures that appropriate action is taken to anticipate, investigate and resolve problems in systems and services. Ensures that such problems are fully documented within the relevant reporting system(s). Coordinates the implementation of agreed remedies and preventative measures. Analyses patterns and trends. Collects and collates evidence as part of a formally conducted and planned review of activities, processes, products or services. Examines records as part of specified testing strategies for evidence of compliance with management directives, or the identification of abnormal occurrences. Other duties as assigned. subject to change at any time. Reporting Relationships: Reports to Senior Managers. Will not have direct reports. Travel: TBD Estimated Salary Range: $89,100-$127,000 Annually. US Physical Requirements: Will sit, stand or walk short distances for up to the entire duration of a shift. Will climb stairs on an occasional basis. Will lift, push or pull up to 37 pounds on an occasional basis. Required to use hands to grasp, lift, handle, carry or feel objects on a frequent basis. 20/40 vision in both eyes together, with or without correction, is required. Must be able to comply with all safety standards and procedures. May reach above shoulder heights and below the waist on a frequent basis. May stoop, kneel, or bend, on an occasional basis. Ability to wear personal protective equipment is required (including but not limited to; steel-toed shoes, gloves, safety glasses, hearing protection, protective jacket or apron and arm guards, and a condition of employment and continued employment (requires little or no facial hair) for those requiring respirator use. Office Physical Requirements: All positions in our office require interaction with people and technology while either standing or sitting. In order to best service our customers, internal and external, all associates must be able to communicate face-to-face and on the phone with or without reasonable accommodation. First Solar is committed to compliance with its obligations under all applicable state and federal laws prohibiting employment discrimination. In keeping with this commitment, it attempts to reasonably accommodate applicants and employees in accordance with the requirements of the disability discrimination laws. It also invites individuals with disabilities to participate in a good faith, interactive process to identify reasonable accommodations that can be made without imposing an undue hardship. Potential candidates will meet the education and experience requirements provided on the above job description and excel in completing the listed responsibilities for this role. All candidates receiving an offer of employment must successfully complete a background check band any other tests that may be required. Equal Opportunity Employer Statement: First Solar is an Equal Opportunity Employer that values and respects the importance of a diverse and inclusive workforce. It is the policy of the company to recruit, hire, train and promote persons in all job titles without regard to race, color, religion, sex, age, national origin, veteran status, disability, sexual orientation, or gender identity. We recognize that diversity and inclusion is a driving force in the success of our company.

USM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development, IT Outsourcing and Technology assistance supplier headquartered in Chantilly, VA with off-shore delivery centers in India. We offer world-class ability in giving most astounding quality and administrations through industry best practices planned to convey remarkable worth to our customers. Utilizing our industry knowledge, administration service offering expertise and innovation abilities, we distinguish new business and innovation slants and create answers for help customers around the globe, giving top of the line solid and practical IT benefits which are cost effective services. Established in 1999, the organization has corner qualities in building and dealing with a Business Oriented IT environment with rich involvement in technology innovation, ERP and CRM counselling, Product Engineering, Business Intelligence, Data Management, SOA, BPM, Data Warehousing, SharePoint Consulting and IT Infrastructure. Our other offerings include modified solutions and administrations in ERP, CRM, Enterprise architecture, offshore advisory services ,e-commerce, Social , Mobile, Cloud, Analytics (SMAC) and DevOps. USM, a US ensured Minority Business Enterprise (MBE) is perceived as one of the fastest developing IT Systems Integrator in the Washington, DC zone. Most as of late, USM was positioned #9 on the rundown of the Top administrations organizations in the DC Metro Area - Washington Business Journal (2011). We are a project-driven firm that reliably meets the IT needs of our State and Government customers through development and business keenness. Job Description Job Title: Reports Developer Location: Fairfax- will require on site during contract, but has the potential to work remotely later Duration: 4 Month CTH Max Rate: $50-55/hr on C2C or 1099 Converting Sal: Up to 120k Must be Locals to VA/MD/DC - Face to face required Only Required: US Citizens with Secret Clearance Provide analytical support and expertise for federal clients. Ability to develop reports and solutions in a fast-paced, high-energy environment. Participate in/create requirements and design documentation, develop and execute code, perform detailed quality checks, debug, and maintain programs. Ability to interpret client requirements and develop forward-looking strategies and solutions. Essential Job Functions: Under general direction, work with customers to realize data requirements for client reporting and data needs. Work with database administrators of source systems to understand the logic for the databases for which the users need to build custom reports. Develop reports in one or more business intelligence (BI) reporting tools, including SQL Server Reporting Services (SSRS), Tableau, or ClickView. Assist the client in the review of warehouse data to outline business intelligence applications that enhances business decision-making capabilities. Maintain responsibility for gathering requirements, designing and developing reports, and the deploying, administering, and maintaining reports. Performs advanced quantitative or qualitative analyses to assist in the identification of client issues and the development of client specific solutions. Assists in the design and structures of presentations that are appropriate to the characteristics or needs of the audience. Analyzes code to find causes of errors and revises programs. Provides technical solutions to inquiries from others regarding errors, problems, or questions about analyses or information reports. Consults and coordinates with systems analysts and programmers to design and develop automated business systems. Must be comfortable interfacing directly with clients. Must be able to present technical solutions to non-technical clients. The ability to be innovative and flexible. Minimum Education, Experience, & Specialized Knowledge Required: Bachelor's degree in Computer Science or related discipline or knowledge acquired through equivalent experience. Fifteen (15) years of hands-on experience with task specific project, to include three (3) of the following four (4) areas: Systems Requirements, Operational Requirements, Test & Evaluation, and Training. Incumbent possesses and has demonstrated intermediate to advanced, and some specialized systems and programming, Knowledge with a minimum of 3 years' experience in systems analysis/application programming. Knowledge of SQL Server 2008 or higher SSIS and Transact-SQL required. Proven experience with other business intelligence software in one or more of the following: Tableau, Microsoft SQL Server Analysis Services, Reporting Services, Excel Services, Microsoft SharePoint, Performance Point, Crystal Reports, Business Objects, SPSS, SAS. Desirable Skills and Attributes: Excellent Verbal and Written Communication Skills Requires listening skills as well as presentation skills, and should be comfortable conducting interviews and discussions with clients and other stakeholders to collect information. Requires exceptional analytical ability to evaluate information and fluency in writing for the preparation of reports. Must be organized and have good interpersonal skills. Other Qualifications: Must be a US Citizen with at least a Secret clearance. Experience working with DoD or Military Health Systems a plus. Additional Information If you are interested in above position, please share your updated resume to ***************************** or can directly call me on ************.

NRI North America is looking for an Azure Data and Analytics Consultant to join our growing team. You will work alongside your peers to design, build, and deliver end-to-end data and analytics solutions for enterprise clients. You should have data engineering experience in Azure and be familiar with modern data platform technologies like Azure Analysis Services, Azure Data Lake, Azure Databricks, Azure Data Warehouse, and Azure Data Factory. Essential Duties Discuss best practices and strategies for modern data and analytics with clients Integrate data sources to build models and reports for business users Configure and operationalize cloud infrastructure in Azure Speak intelligently to Microsoft's cloud data strategy and roadmap Stay current Microsoft technologies and modern data platform best practices Required Skills - Consulting Ability to work independently and as a member of a team Strong written and oral communication skills Strong troubleshooting skills Ability to adjust to new client cultures and projects Adapt positively to change by embracing new practices, processes, or circumstances Present a positive, professional, and self-confident image Respond to clients in a timely and professional manner Understand and strive to consistently meet or exceed client expectations Collaborate with clients to identify and address their business needs Communicate accurately, concisely, and effectively Respectfully listen to others' ideas and concerns with an open mind Required Skills - Leadership Display a strong commitment to NRI's vision, mission, and values Meet commitments to others and deliver on time Hold self and others accountable for responsibilities Accept responsibility for own decisions and actions without excuses Self-starter Required Skills - Technical Data engineering experience in Azure and be familiar with modern data platform technologies like Azure Analysis Services, Azure Data Lake, Azure Databricks, Azure Data Warehouse, and Azure Data Factory. 3+ years of experience in data engineering and modeling Ability to design an end-to-end data analytics solution architecture and drive its implementation Deep understanding of Agile engineering practices Data Warehousing Data ETL/ELT Data Modeling (Dimensional/Kimball) T-SQL Azure Data Factory (or strong SSIS experience) Azure Data Lake Store SQL Server/Azure SQL Azure Analysis Services or SQL Server Analysis Services (SSAS) - Tabular Azure DevOps/Continuous Integration & Continuous Delivery Preferred and Desirable Skill - Technical Azure Synapse/Azure SQL Data Warehouse Power BI/DAX Databricks Azure Functions Azure Logic Apps Azure AD Data Vault Database administration and performance tuning SQL Server Integration Services (SSIS) Python Application development experience Previous consulting experience HDFS Azure Stream Analytics/Azure Event Hub Azure Data Lake Analytics/Apache Hive Azure Cosmos DB Apache Spark/HDInsight PowerShell .NET development R/Scala ASP.NET MVC/Web API Snowflake/BigQuery/Redshift Benefits - You'll love working at NRI not just for the usual benefits, but for our environment and culture! You'll work with a great group of people in a highly collaborative team and results oriented atmosphere You'll have the opportunity to work in a dynamic and extremely positive environment where there is always the opportunity to challenge your skills and really move the needle You'll work with large, sophisticated, and progressive clients throughout North America We provide a comprehensive benefits program including: $0 Healthcare option, company contribution to Health Savings Account with enrollment in a qualifying plan, 401(k) plus company match, Professional Development funds, Flexible Time Off (FTO) plus 11 company holidays, 4 weeks Parental/Caregiver Leave, company paid family building/fertility benefits through Progyny, Dental and Vision Insurance, and company paid Life/AD&D, short term and long term disability insurance. Notices The above description is intended to describe the general nature and level of work performed by individuals assigned to this position. This is not intended to be an exhaustive list of all responsibilities, duties, knowledge, skills, or experience required of individuals in this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential duties and responsibilities. NRI North America is proud to be an Equal Opportunity/Affirmative Action employer. NRI North America will accept applications on an ongoing basis. NRI North America will consider qualified candidates with criminal histories in a manner consistent with The Los Angeles Fair Chance Initiative for Hiring Ordinance. If you require reasonable accommodation in completing an application, interviewing, or otherwise participating in the hiring process, please direct your inquiries to ***********************.

🌟 Ready to Power Up Your Career? 🌟 Senior Business Systems Analyst | Remote ✅ Flexibility: Work remotely or in-office ✅ Opportunity to innovate and make a real impact ✅ Collaborative, tech-driven environment Join us as a Systems Analyst and supercharge innovation by building sleek PowerBI dashboards, automating data workflows, and harnessing your SQL, Python, and AWS skills to turn complex data into powerful insights 👉 Apply today and let's create something extraordinary! 🚀 Bachelor's degree in a relevant field (e.g., Computer Science, Data Science, Business Analytics) Minimum three years of experience in data modeling and data visualizations Proficiency in data analysis, data modeling, and data visualization is required, utilizing tools like PowerBI, Dash Plotly, Tableau, and Excel. Experience with cloud-based data management technologies, especially AWS S3, is necessary to leverage the scalability and efficiency of cloud computing. Be able to develop and maintain data pipelines, manage data warehousing, and execute ETL processes using technologies such as Redshift AWS, AWS Glue, SSRS, and SSAS. Proficiency in SQL and Python is expected for data manipulation and analysis Ability to communicate ideas and information verbally, both one-on-one and in meetings, in a manner that is clear and concise. Presents prepared information in a manner that holds customers' interest and addresses their needs and concerns. Able to adjust presentation styles to correspond to the audience being addressed. Ability to present written information in a clear, concise and organized manner. Writes technical information so that it can be understood by non-technical audiences. Ability to manage own time, activities & resources. Identifies work activities needed to accomplish objectives & coordinates those activities to deliver desired results. Prioritizes multiple activities & projects. Ability to gather and analyze facts and data and to draw correct inferences from the information. Excellent written and verbal communication skills. Ability to make practical, timely and realistic decisions after considering possible outcomes as well as corresponding risks. Work beyond a normal 40 hour week may be required to meet project deadlines. #LI-DV1 Leverage experience with cloud-based data management technologies, particularly AWS S3, to ensure scalability and efficiency in data operations. Collaborate with the IT team to design and implement cloud-based data solutions that align with organizational objectives. Leverage experience with cloud-based data management technologies, particularly AWS S3, to ensure scalability and efficiency in data operations. Develop and maintain robust data pipelines to ensure efficient data extraction, transformation, and loading (ETL) processes. Manage data warehousing solutions to support the organization's data needs, potentially using Redshift AWS. Execute ETL processes using technologies like AWS Glue, SSRS (SQL Server Analysis Services). Recommends improvements to existing technologies & methods, to improve the quality/timeliness of technical & customer support. Delivers quality and timely results, i.e., technical and customer support, based on company business needs and objectives. Recommends and implements improvements to existing technologies and methods or proposes new ones, to improve the quality and timeliness of technical and customer support. Delivers quality & timely results, i.e., technical and customer support, based on company business needs and objectives. Maintains state-of-the-art knowledge within areas of responsibility. Fosters the development of technical knowledge and performance skills of technicians. Complies with and supports all corporate, department and unit policies and procedures. Keeps manager, project teams & business unit customers informed of activities & problems within assigned areas of responsibility; refers matters beyond limits of authority to manager for direction. Presents technology capabilities to internal and external parties as needed. Provides technology demonstrations for sales/prospect meetings as needed. Support operations as needed at prospect meetings during implementation and post go live. Tracks, monitors and updates senior leadership in ops on all elements related to enhancements, upgrades and chances to the business technology platform. Supports other projects and other areas as needed on projects that span across own business unit. Performs other related duties as required or requested. Upholds the Crawford Code of Business Conduct at all times. Participates in special projects or performs duties in other areas as requested.